00:00:00
SELECT DATEADD(day,DATEDIFF(day,'20010101',CURRENT_TIMESTAMP),'20010101');
23:59:59
select getdate(),convert(datetime,convert(varchar,getdate(),112),112)+1-1.0/3600/24
00:00:00
SELECT DATEADD(day,DATEDIFF(day,'20010101',CURRENT_TIMESTAMP),'20010101');
23:59:59
select getdate(),convert(datetime,convert(varchar,getdate(),112),112)+1-1.0/3600/24