Product Solutions Support
Try MemSQL

UNIX_TIMESTAMP

Returns the current Unix time as an integer, or converts the given date into unixtime.

UNIX_TIMESTAMP ( dateobj )

Arguments

Return Type

Integer

Examples

memsql> select unix_timestamp();
+------------------+
| unix_timestamp() |
+------------------+
|       1425430836 |
+------------------+

memsql> select unix_timestamp('2009-02-13 23:31:30') as funday;
+------------+
| funday     |
+------------+
| 1234567890 |
+------------+
Was this article useful?