DATETIME
Syntax
DATETIME( expression [ , timezone ] )
Description
Converts the expression expression to date and time format. When converting Date to DateTime, the time is set to '00:00:00'.
The date must be in the format YYYY-MM-DDThh:mm:ss or YYYY-MM-DD hh:mm:ss.
Numeric values are rendered as time in Unix time format or equal to the number of seconds elapsed since 00:00:00 on January 1, 1970, less the adjustments for leap seconds.
The date and time can be converted to the specified time zone when the timezone option is available. The timezone parameter must be specified in Region/Data_Zone format.
Argument types:
expression—Date | Datetime | Fractional number | Integer | Stringtimezone—String
Return type: Datetime
Note
Only constant values are accepted for the arguments (timezone).
Note
Argument timezone is available only for ClickHouse sources.
Examples
DATETIME("2019-01-23 15:07:47") = #2019-01-23 15:07:47#
DATETIME("2019.01.02 03:04:05") = #2019-01-02 03:04:05#
DATETIME("2019-01-23") = #2019-01-23 00:00:00#
DATETIME(1576807650) = #2019-12-20 02:07:30#
DATETIME(1576807650.793) = #2019-12-20 02:07:30#
DATETIME(1576807650.793, 'Asia/Hong_Kong') = #2019-12-20 10:07:30#
Data source support
ClickHouse 21.8, Files, Google Sheets, Yandex Metrica, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Yandex Documents, YDB.