sqlite将时间转换为本地时间读取

select datetime(timestamp, 'localtime')

https://stackoverflow.com/questions/381371/sqlite-current-timestamp-is-in-gmt-not-the-timezone-of-the-machine