--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,00,59,07,23,SqlServer,CONVERT From: https://www.cnblogs.com/hofmann/p/17545450.html