mysql标准时间转换为一周_mysql及date时间戳与标准时间转换

时间戳 to 标准时间

FROM_UNIXTIME(xxxxxxxxxx);

mysql> select FROM_UNIXTIME("1290214840");

+-----------------------------+

| FROM_UNIXTIME("1290214840") |

+-----------------------------+

| 2010-11-20 09:00:40         |

+-----------------------------+

1 row in set (0.03 sec)

标准时间 to 时间戳

UNIX_TIMESTAMP('YYYY-MM-DD HH:MM:SS'');

mysql> select UNIX_TIMESTAMP("2010-11-20 09:00:40");

+---------------------------------------+

| UNIX_TIMESTAMP("2010-11-20 09:00:40") |

+---------------------------------------+

|                            1290214840 |

+---------------------------------------+

1 row in set (0.02 sec)

date时间戳与标准时间转换

# date  -d "2010-12-31 12:45:20" +%s

# 1293770720# date -d @1293770720

# Fri Dec 31 12:45:20 CST 2010