Home Forums SQL Server 2005 T-SQL (SS2K5) Working Out Exact Age with DateDiff RE: Working Out Exact Age with DateDiff

  • July 20, 2009 at 8:55 am

    #1027017

    Also datediff counts boundaries, not calendars

    try this

    select datediff(yy,'31dec2009','01jan2010')


    Clear Sky SQL
    My Blog[/url]