SqlServer取当前日期0点到23点59分59秒

--2023-07-11 00:00:00.000    2023-07-11 23:59:59.000
SELECT CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),120)),DATEADD(SECOND,-1,CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE()+1,120)))
--2023-07-11 00:00:00    2023-07-11 23:59:59
select convert(varchar(11),getdate(),120)+'00:00:00',convert(varchar(11),getdate(),120)+'23:59:59'