Home Forums SQL Server 2008 T-SQL (SS2K8) how to get current year RE: how to get current year

  • September 18, 2012 at 6:57 am

    #1539070

    Ummm. . .

    YEAR(GETDATE());

    http://msdn.microsoft.com/en-us/library/ms186313.aspx

    Forever trying to learn
    My blog - http://www.cadavre.co.uk/
    For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
    For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/