With SQL Server 2008 and above, this is simple done executing the query below:
SELECT cast(getDate() AS Date)
For previous versions, the proper way to do it is:
SELECT dateAdd(dd, dateDiff(dd,0, getDate()), 0)
SELECT cast(getDate() AS Date)
SELECT dateAdd(dd, dateDiff(dd,0, getDate()), 0)
0 comments:
Post a Comment