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         |