TIMESTAMP
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. If dateobj is not a valid date, returns NULL.
Remarks
TIMESTAMPis 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 setTIMESTAMPto its minimum value (1970-01-01 00:00:01), the query will insert0000-00-00 00:00:00.The
TIMESTAMPfunction supports improved segment elimination when used inWHEREclauses. See the following query example:SELECT ... FROM table_name WHERE TIMESTAMP(column_name) > '2000-01-01 00:00:00' AND TIMESTAMP(column_name) <= '2015-03-03 00:00:00';
Examples
SELECT TIMESTAMP('2015-03-03');
****
+-------------------------+
| TIMESTAMP('2015-03-03') |
+-------------------------+
| 2015-03-03 00:00:00 |
+-------------------------+
Related Topics