1.时间查询
Table name : Table
Filed: UserDate
Data: 2008-1-17 22:10:02
时间段查询 select top 4 * from Table where
UserDate between '2008-1-17 22:10:02' and '2008-1-17 22:10:02'
时间点查询 select * from Table where UserDate='2008-1-17 22:10:02'
模糊查询 select * from Table where Convert(Varchar(10),UserDate,120) like '2008-1-%'
select * from Table where Convert(Varchar(23),UserDate,120) like '2008-1-17 15:%'
select * from Table where Convert(Varchar(23),UserDate,120) like '2008-1-17 %46:%'
access:用#代替上面的'
2.时间的比较
Select * From Table Where DateDiff(s,GetDate(),UserDate)>0
这个更快一点 Select * From Table Where UserDate>GetDate()
access: Select * From Table Where thetime>#"& Now() &"#