JZTXT

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

发布时间 2023-07-11 17:39:35作者: hofmann
--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'