Home Forums SQL Server 2005 T-SQL (SS2K5) Get Date only from getdate() function RE: Get Date only from getdate() function
brosspaxedi
SSCommitted
Points: 1591
More actions
April 1, 2010 at 7:08 am
#1143923
If I'm not mistaken, SELECT CAST(GETDATE() AS DATE) will only work on SS2008 and above, as the DATE type is new in 2008.
*******************What I lack in youth, I make up for in immaturity!