• DBA (5/5/2009)


    sorry i edited

    29

    29

    62

    677

    677

    [font="Verdana"]That looks like the number of days from 1900-01-01. So your conversion will be something like:

    datediff(day, '19000101', MyDate)

    ...where MyDate is the name of the column containing the datetime value.

    [/font]