select * from table where date>='2001/03/07 10:00:00' and date<='2000/03/08 10:00:00'时间可以自己设置或自动生成。
可用自定义的时间格式化字符串,sybase的数据库支持毫秒级,其他的你自己看看了
好,精确到分钟: select * from [table] where datediff(mi,datefield,getdate())<=24*60 精确到小时: select * from [table] where datediff(hh,datefield,getdate())<=24ok,拿分来 *~_~*
dim a as date dim b as date a="2001/03/07 10:00:00" b="2001/03/08 10:00:00" c=datediff("n",a,b) d=datediff("h",a,b)
对了,你的数据库是sql server吗?如果是的话: select * from [table] where datefield>=(getdate()-1) 就搞定了。你试一下。
select * from [table] where datediff(mi,datefield,getdate())<=24*60
精确到小时:
select * from [table] where datediff(hh,datefield,getdate())<=24ok,拿分来 *~_~*
dim b as date
a="2001/03/07 10:00:00"
b="2001/03/08 10:00:00"
c=datediff("n",a,b)
d=datediff("h",a,b)
select * from [table] where datefield>=(getdate()-1)
就搞定了。你试一下。