DATE
Syntax
DATE( expression [ , timezone ] )
Description
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 arguments (timezone).
Note
Argument timezone is available only for Materialized Dataset, ClickHouse sources.
Examples
DATE("2019-01-23") = #2019-01-23#
Data source support
Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, Oracle Database 12c (12.1), PostgreSQL 9.3.