UNIX_TIMESTAMP

UNIX_TIMESTAMP [date]
  • 命令说明：返回1970-01-01 00:00:00 UTC以来的秒数。
  • 示例：
      SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19.1') as col1
  +--------------------+
  | _col0              |
  +--------------------+
  | 1447381219         |