DATE
Syntax
DATE( expression [ , timezone ] )
Description
Warning
For ClickHouse data sources, numeric expression values less than or equal to 65535 are interpreted as the number of days (not seconds, like in all other cases) since January 1st 1970. This is the result of the behavior of available ClickHouse functions.
One way to surpass this is to use the following formula: DATE(DATETIME([value])). The result is more consistent, but is likely to be much slower.
Converts the expression expression to date format.
The date must be in the format YYYY-MM-DD.
If expression is a number, then the timezone option can be used to convert the date to the specified time zone.
Argument types:
expression—Date | Datetime | Fractional number | Integer | Stringtimezone—String
Return type: Date
Note
Only constant values are accepted for the arguments (timezone).
Note
Argument timezone is available only for ClickHouse sources.
Example
DATE("2019-01-23") = #2019-01-23#
Data source support
ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.