sql查询当天的充值记录导入
sql code
--查询当天的数据
select * from a where generateTime=sysdate
--查询一个星期的数据
select * from a where (sysdate-generaeTime)=7
--查询一个月的数据
select * from a where months_between(sysdate,generateTime)=1
--查询某一天的数据
select * from table where col between ‘2009-7-17‘ and ‘2009-7-18‘
select * from tb where datetime >‘2010-5-14‘ and datetime
--一周内
SELECT * FROM TB WHERE datediff(dd,DATE_TIME,getdate()) <= 7
SELECT * FROM TB WHERE datediff(dd,DATE_TIME,getdate()) between 0 and 7
--从现在起往前算24小时内
SELECT * FROM TB WHERE dateiff(hh,DATE_TIME,getdate())<=24
SELECT * FROM TB WHERE datediff(hh,DATE_TIME,getdate()) between 0 and 23--
--如果是datetime的话
select 姓名,sum(价格) as 总金额 from 销售表 where convert(varchar(6),成交时间,112)=‘201311‘ group by 姓名
--如果日期是字符型的话
sel