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

• TIMESTAMP is based on UTC timezones.

• SingleStore converts TIMESTAMP values from the current timezone to UTC for storage.

• Minimum value: when setting a value for TIMESTAMP, if your UTC timezone is before UTC (set to UTC +<hours>) and you set TIMESTAMP to its minimum value (1970-01-01 00:00:01), the query will insert 0000-00-00 00:00:00.

• The TIMESTAMP function supports improved segment elimination when used in WHERE clauses. See the following query example:

  SQL

  Copy

  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

• TIMESTAMPADD

• TIMESTAMPDIFF