下面是具体的实现代码：

1. sqlite> SELECT datetime(1377168853, 'unixepoch', 'localtime');
   
2. 
   
3. +------------------------------------------------+
   
4. | datetime(1377168853, 'unixepoch', 'localtime') |
   
5. +------------------------------------------------+
   
6. | 2013-08-22 18:54:13              |
   
7. +------------------------------------------------+
   
8. 1 row in set
   
9. 
   
10. sqlite> SELECT strftime('%s','now');
    
11. +----------------------+
    
12. | strftime('%s','now') |
    
13. +----------------------+
    
14. | 1380728519      |
    
15. +----------------------+
    
16. 1 row in set
    
17. 
    
18. sqlite> SELECT datetime('now');
    
19. +---------------------+
    
20. | datetime('now')   |
    
21. +---------------------+
    
22. | 2013-10-02 15:40:44 |
    
23. +---------------------+
    
24. 1 row in set

复制代码

来源：https://www.jb51.net/article/51545.htm
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！