DATETIME
Type conversion functions
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.
If expression is a number, then the date and time can be converted to the specified time zone when the timezone option is available.
Argument types:
expression—Date | Datetime | Number | Stringtimezone—String
Return type: Datetime
Note
Only constant values are accepted for arguments (timezone).
Note
Argument timezone is available only for Materialized Dataset, ClickHouse sources.
Examples
DATETIME("2019-01-23 15:07:47") = #2019-01-23 15:07:47#
Data source support
Materialized Dataset, ClickHouse 1.1, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.