SQL server时间查询

最新推荐文章于 2024-07-06 14:11:02 发布

zhenlimeng1983

最新推荐文章于 2024-07-06 14:11:02 发布

阅读量187

点赞数

文章标签： SQL Server SQL .net Blog

本文链接：https://blog.csdn.net/zhenlimeng1983/article/details/83433182

版权

table name : dbo.tbBas_Subject

datefiled: CreateDate

data: 2006-10-27 15:46:02.937 <时间格式>

时间段查询 select top 4 * from dbo.tbBas_Subject where
CreateDate between '2006-10-27 15:46:02.937' and '2006-10-27 16:17:15.377'

时间点查询 select * from dbo.tbBas_Subject where CreateDate='2006-10-27 16:17:15.377'

模糊查询 select * from tbBas_Subject where Convert(Varchar(10),CreateDate,120) like '2006-10-%'

select * from tbBas_Subject where Convert(Varchar(23),CreateDate,120) like '2006-10-27 15:%'

select * from tbBas_Subject where Convert(Varchar(23),CreateDate,120) like '2006-10-27 %46:%'

本文来自CSDN博客，转载请标明出处：http://blog.csdn.net/fly_bird2008/archive/2007/09/06/1774409.aspx