TIMESTAMP
On this page
Convert the input argument to a datetime object.
Syntax
TIMESTAMP(dateobj)
Arguments
-
dateobj: a valid date, datetime, or parsable date string.
Return Type
Datetime object.
Remarks
-
TIMESTAMP
is based on UTC timezones. -
Minimum value: when setting a value for
TIMESTAMP
, if your UTC timezone is before UTC (set to UTC +<hours>) and you setTIMESTAMP
to its minimum value (1970-01-01 00:00:01
), the query will insert0000-00-00 00:00:00
.
Examples
SELECT TIMESTAMP('2015-03-03');
+-------------------------+
| TIMESTAMP('2015-03-03') |
+-------------------------+
| 2015-03-03 00:00:00 |
+-------------------------+
Related Topics
Last modified: May 31, 2023