TIME_TO_USEC

Declaration

TIME_TO_USEC(date)

Description

Converts the date value to the number of microseconds since 1970-01-01 00:00:00.000000, considering the timezone.

date can represent a date or a datetime.

Example

SELECT TIME_TO_USEC('2014-03-25'), TIME_TO_USEC(NOW());
+----------------------------+---------------------+
| TIME_TO_USEC('2014-03-25') | TIME_TO_USEC(NOW()) |
+----------------------------+---------------------+
|           1395676800000000 |    1765965060000000 |
+----------------------------+---------------------+
1 row in set (0.001 sec)