DAYS

days(expr)

Description

Returns the number of days from the epoch (1970-01-01 00:00:00) to the specified timestamp.

Parameters

• expr: An expression of type date/timestamp_ltz/timestamp_ntz.

Returns

• bigint type, representing the number of days since the epoch.

Examples

SELECT days(timestamp_ntz '1970-01-01 00:00:00'); -- Result: 0

SELECT days(timestamp_ntz '2000-01-01 00:00:00'); -- Result: 10957

SELECT days(timestamp_ntz '2020-08-09 03:04:05'); -- Result: 18483