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:

    • expressionDate | Datetime | Fractional number | Integer | String
    • timezoneString

    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 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.