下面是具体的实现代码：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
sqlite> SELECT datetime(1377168853, 'unixepoch' , 'localtime' );
+ ------------------------------------------------+ | datetime(1377168853, 'unixepoch' , 'localtime' ) | + ------------------------------------------------+ | 2013-08-22 18:54:13 | + ------------------------------------------------+ 1 row in set
sqlite> SELECT strftime( '%s' , 'now' ); + ----------------------+ | strftime( '%s' , 'now' ) | + ----------------------+ | 1380728519 | + ----------------------+ 1 row in set
sqlite> SELECT datetime( 'now' ); + ---------------------+ | datetime( 'now' ) | + ---------------------+ | 2013-10-02 15:40:44 | + ---------------------+ 1 row in set |
查看更多关于sqlite时间戳转时间语句(时间转时间戳)的详细内容...