I have a column that stores dates and other that stores times, but they are not in a readable format i.e.
Date Time
42017 0,453545345351222
42015 0,022323223232333
I suppose that the values in "Date" corresponds to the number of days since 1900-01-01 and the value in "Time" is the fraction of a day i.e. 0,45 is more or less 10h40m00s.
In sql server 2005 how can I convert these values to human readable format?
Aucun commentaire:
Enregistrer un commentaire