select createtime,content,strftime('%Y-%m-%d',datetime(createtime,'unixepoch','localtime')) as ct from ch_Log where ct = '2017-10-11'
select createtime,content,strftime('%Y-%m-%d',datetime(createtime,'unixepoch','localtime')) as ct from ch_Log where ct = '2017-10-11'
本文标题：SQLITE 中时间戳转日期
本文链接：https://www.haomeiwen.com/subject/mjrrzftx.html
网友评论