34,590
社区成员
发帖
与我相关
我的任务
分享
select
convert(varchar(11),getdate(),120)+'00:00:00',
convert(varchar(11),getdate(),120)+'23:59:59'
/**
------------------- -------------------
2009-10-22 00:00:00 2009-10-22 23:59:59
(1 行受影响)
**/
SELECT CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),120))
SELECT DATEADD(SS,-1,DATEADD(DD,1,CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),120))))
------------------------------------------------------
2009-10-22 00:00:00.000
(所影响的行数为 1 行)
------------------------------------------------------
2009-10-22 23:59:59.000
(所影响的行数为 1 行)
SELECT CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),120))
SELECT DATEADD(SS,-1,CONVERT(DATETIME,CONVERT(VARCHAR(10),GETDATE(),120)))
------------------------------------------------------
2009-10-22 00:00:00.000
(所影响的行数为 1 行)
------------------------------------------------------
2009-10-21 23:59:59.000
(所影响的行数为 1 行)
between getdate() and dateadd(day,1,getdate())