lundi 4 mai 2015

Convert date to readable format

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