Convert an interger to year month and days

  • Hello,

    Is there a way using TSQL to convert an integer to year, month and days

    for e.g. 365 converts to 1year 0 months and 0 days

    366 converts to 1year 0 months and 1 day

    20 converts to 0 year 0 months and 20 days

    200 converts to 0 year 13 months and 9 days

    408 converts to 1 year 3 months and 7 days .. etc

    many thanks,

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • Please post answers here

    http://www.sqlservercentral.com/Forums/Topic1223326-392-1.aspx

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply