Product Solutions Support
Try MemSQL

TIME_TO_SEC

Returns the number of seconds from midnight.

TIME_TO_SEC ( dateobj )

Arguments

Return Type

Integer

Examples

memsql> select time_to_sec('2009-02-13 23:31:30');
+------------------------------------+
| time_to_sec('2009-02-13 23:31:30') |
+------------------------------------+
|                              84690 |
+------------------------------------+
Was this article useful?