论坛 › php › php FROM_UNIXTIME(CreateDate,'%Y-%m-%d %H:%i:%s')

史蒂夫和斯凯 发表于 2017-4-11 10:47:02

php FROM_UNIXTIME(CreateDate,'%Y-%m-%d %H:%i:%s')

mysql时间戳:
插入时间戳:
INSERT INTO comment(CreateDate,content)values(UNIX_TIMESTAMP(),'content')
取到时间戳:
SELECT content FROM_UNIXTIME(CreateDate,'%Y-%m-%d %H:%i:%s') as CreateDate FROM comment
%Y-%m-%d %H:%i:%s 表示:2008-12-25 18:23:33
UNIX_TIMESTAMP()和FROM_UNIXTIME(CreateDate,'%Y-%m-%d %H:%i:%s')配对

查看完整版本: php FROM_UNIXTIME(CreateDate,'%Y-%m-%d %H:%i:%s')