select DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0)
or
select CONVERT(DATE, getdate(), 101)
or
SELECT CONVERT(DATE,GETDATE())
or
SELECT CAST(FLOOR(CAST(getdate() AS FLOAT)) AS DATETIME)
or
select CONVERT(DATE, getdate(), 101)
or
SELECT CONVERT(DATE,GETDATE())
or
SELECT CAST(FLOOR(CAST(getdate() AS FLOAT)) AS DATETIME)
No comments:
Post a Comment