sqlite时间戳转时间语句(时间转时间戳)
下面是具体的实现代码:
sqlite>SELECTdatetime(1377168853,'unixepoch','localtime'); +------------------------------------------------+ |datetime(1377168853,'unixepoch','localtime')| +------------------------------------------------+ |2013-08-2218:54:13| +------------------------------------------------+ 1rowinset sqlite>SELECTstrftime('%s','now'); +----------------------+ |strftime('%s','now')| +----------------------+ |1380728519| +----------------------+ 1rowinset sqlite>SELECTdatetime('now'); +---------------------+ |datetime('now')| +---------------------+ |2013-10-0215:40:44| +---------------------+ 1rowinset