怎样取得某天的最早时间和最晚时间

Question

cast('2003-12-19 23:59:59' as datetime)

Answer 1

cast('2003-12-19 23:59:59' as datetime)
cast('2003-12-19 0:00:00' as datetime)是这意思吗？

Answer 2

select convert(datetime,convert(varchar(10),getdate(),120)+' '+'00:00:00')select convert(datetime,convert(varchar(10),getdate(),120)+' '+'23:59:59')

Answer 3

今天的最早时间（2003-12-19 0:00:00）？select dateadd(dd,datediff(dd,0,getdate()),0)今天的最晚时间（2003-12-19 23:59:59）select dateadd(s,-1,datediff(dd,-1,getdate()))

Answer 4

select convert(varchar(10),getdate(),120) + ' 23:59:59'
select convert(varchar(10),getdate(),120) + ' 0:00:00'

Answer 5

select dateadd(second,-1,dateadd(day,1,(convert(char(10),getdate(),102))))

Answer 6

select cast ((convert(char(10),getdate(),102)) as datetime)

Answer 7

declare @ datetime
set @ = getdate()select dateadd(day,0-datediff(day,@,0),0)
,dateadd(second,-1,dateadd(day,0-datediff(day,@,0)+1,0))

Answer 8

to freshrabbit () 
难道你看不懂吗?declare @ datetime
set @ = getdate()select dateadd(day,0-datediff(day,@,0),0)
,dateadd(second,-1,dateadd(day,0-datediff(day,@,0)+1,0))