22,206
社区成员
发帖
与我相关
我的任务
分享
if object_id('tempdb..#')is not null drop table #
go
create table #(dtTime datetime)
insert # select '2009-08-12 17:21:00.000'
insert # select '2008-08-11 17:21:00.000'
insert # select '2008-09-11 16:21:00.000'
insert # select '2007-06-11 08:21:00.000'
select * from # where datepart(mm,dtTime)='08' and datepart(dd,dtTime)='11'
and datepart(hh,dtTime)='17'
/*dtTime
------------------------------------------------------
2008-08-11 17:21:00.000
*/
selelct convert(varchar(40),dtTime) from xx
select datediff(hh,'2008-11-27 18:00:00',getdate())
-----------
3