Post reply

Date format question

  • August 9, 2006 at 7:59 am

    #113847

    I've got a table with the date stored in a six digit format such as 732503. I can not figure out how to convert that to a date format. The best I can do is find out that it is a Gregorian serial date. Can anyone tell me how to do this?

    Thanks!

  • August 9, 2006 at 8:26 am

    #654087

    If possible, try and get at least two example dates and values. Maybe 2006-08-09 = 732503 and 2006-08-08 = 732502

    You should then be able to work out if it is a Gregoriam offset, a bitwise date etc. There may also be a time component in the date.

     

  • August 9, 2006 at 9:41 am

    #654120

    Thanks for the reply. I found the answer to my question.

    select dateadd(dd, 732533 - 639906, '1/1/1753')

    Thanks.

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

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