Dates & time Scalar

date_diff()

The number of partition boundaries between the timestamps

Arguments & returns

4 overloads

Scalar

Overload link	`part`	`startdate`	`enddate`	Returns
#01	`VARCHAR`	`DATE`	`DATE`	`BIGINT`
#02	`VARCHAR`	`TIME`	`TIME`	`BIGINT`
#03	`VARCHAR`	`TIMESTAMP WITH TIME ZONE`	`TIMESTAMP WITH TIME ZONE`	`BIGINT`
#04	`VARCHAR`	`TIMESTAMP`	`TIMESTAMP`	`BIGINT`

SELECT date_diff('hour', TIMESTAMPTZ '1992-09-30 23:59:59', TIMESTAMPTZ '1992-10-01 01:58:00');

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

DATEDIFF('day', a, b)

In Haybarn

DATE_DIFF('DAY', CAST(a AS TIMESTAMP), CAST(b AS TIMESTAMP))

DATEDIFF(a, b)

In Haybarn

DATE_DIFF('DAY', CAST(b AS DATE), CAST(a AS DATE))

DATEDIFF(a, b)

In Haybarn

DATE_DIFF('DAY', CAST(b AS DATE), CAST(a AS DATE))

DATEDIFF(a, b)

In Haybarn

DATE_DIFF('DAY', CAST(b AS DATE), CAST(a AS DATE))

DATE_DIFF('2021-01-01', '2020-01-01', DAY)

In Haybarn

DATE_DIFF('DAY', CAST('2020-01-01' AS DATE), CAST('2021-01-01' AS DATE))

DATEDIFF(YEAR, '2020-01-15', '2023-06-20')

In Haybarn

DATE_DIFF('YEAR', CAST('2020-01-15' AS DATE), CAST('2023-06-20' AS DATE))