Skip to main content

TO_DAYS

Description

Date calculation function, which is used to convert a date into a day value, that is, to calculate the total number of days from December 31, 0 AD (the base date) to the specified date.

Syntax

TO_DAYS(<datetime_or_date_value>)

Required parameters

ParameterDescription
<datetime_or_date_value>datetime or date type date-time

Example

Query how many days are there since October 7, 2007

select to_days('2007-10-07');
+---------------------------------------+
| to_days(cast('2007-10-07' as DATEV2)) |
+---------------------------------------+
| 733321 |
+---------------------------------------+
select to_days('2007-10-07 10:03:09');
+------------------------------------------------+
| to_days(cast('2007-10-07 10:03:09' as DATEV2)) |
+------------------------------------------------+
| 733321 |
+------------------------------------------------+