MySQL(Unix时间戳、日期)转换函数

unix_timestamp()

?

1 2 3 4 5 6

mysql> select unix_timestamp(); +------------------+ | unix_timestamp() | +------------------+ |       1464590043 | +------------------+

 

unix_timestamp(date)

?

1 2 3 4 5 6 7 8 9 10 11 12 13

mysql> select unix_timestamp('2016-05-30'); +------------------------------+ | unix_timestamp('2016-05-30') | +------------------------------+ |                   1464537600 | +------------------------------+   mysql> select unix_timestamp('2016-05-30 14:35:21'); +---------------------------------------+ | unix_timestamp('2016-05-30 14:35:21') | +---------------------------------------+ |                            1464590121 | +---------------------------------------+

 

from_unixtime(unix_timestamp)

?

1 2 3 4 5 6

mysql> select from_unixtime(1464590043); +---------------------------+ | from_unixtime(1464590043) | +---------------------------+ | 2016-05-30 14:34:03       | +---------------------------+

 

from_unixtime(unix_timestamp,format)

?

1 2 3 4 5 6

mysql> select from_unixtime(1464590043, '%Y %D %M %h:%i:%s %x'); +---------------------------------------------------+ | from_unixtime(1464590043, '%Y %D %M %h:%i:%s %x') | +---------------------------------------------------+ | 2016 30th May 02:34:03 2016                       | +---------------------------------------------------+