--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'
11-25
3991