UNIX_
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Returns the current Unix time as an integer, or converts the given date into unixtime.
Syntax
UNIX_TIMESTAMP ( dateobj )Arguments
-
dateobj: a valid date, datetime, or parsable date string.
Defaults to CURRENT_.TIMESTAMP
Return Type
Integer
Remarks
The UNIX_ function supports improved segment elimination when used in WHERE clauses.
SELECT ... FROM table_name WHERE UNIX_TIMESTAMP(column_name) > UNIX_TIMESTAMP('2000-01-01 00:00:00');
Examples
SELECT UNIX_TIMESTAMP();
+------------------+
| UNIX_TIMESTAMP() |
+------------------+
| 1425430836 |
+------------------+SELECT UNIX_TIMESTAMP('2009-02-13 23:31:30') AS funday;
+------------+
| funday |
+------------+
| 1234567890 |
+------------+Related Topics
Last modified: May 31, 2023