Home Forums SQL Server 2005 SQL Server 2005 Compact Edition Using DateDiff to calculate days before a Birthday RE: Using DateDiff to calculate days before a Birthday
kenkob
SSChasing Mays
Points: 642
More actions
September 10, 2010 at 7:29 am
#1219145
Jeff,
Just entering SELECT YEAR(GETDATE()) give the error Function is not recognized by SQL Server Compact Edition of Function [Year]
Running DATEPART returned 2010