sqlite 取日期的方法:年,季度,月,当月第几周
数据库为 sqlite3 答案如下: select ActionDate ----------------------------------------------------------------------------------------- 用strftime 函数
select * from tblWord where strftime("%d",updatedate)='26' 表示查询日期为26的数据。比如2012-9-26 SELECT julianday('now') - julianday('1776-07-04'); 表示1776-7-4 距离今天有多少天 http://www.sqlite.org/lang_datefunc.html
select cast(27.33 as int) -- 27
SELECT (0<=cast((julianday('now') - julianday(Updatedate)) as int) and 7>=cast((julianday('now') - julianday(Updatedate)) as int)) as Latest1Week -- 最近1周,(0<=cast((julianday('now') - julianday(Updatedate)) as int) and 31>=cast((julianday('now') - julianday(Updatedate)) as int)) as Latest1Month -- 最近1个月,(0<=cast((julianday('now') - julianday(Updatedate)) as int) and 93>=cast((julianday('now') - julianday(Updatedate)) as int)) as Latest3Month -- 最近3个月,(0<=cast((julianday('now') - julianday(Updatedate)) as int) and 365>=cast((julianday('now') - julianday(Updatedate)) as int)) as Latest1Year -- 最近1年 from tblWord (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |