获取今天的00:00:00
select
convert
(datetime,
convert
(
varchar
(10),getdate(),120))
获取今天的23:59:59
1、select
dateadd(ss,-1,dateadd(dd,1,
convert
(datetime,
convert
(
varchar
(10),getdate(),120))))
2、select convert(datetime,convert(varchar,getdate(),112),112)+1-1.0/3600/24