Excel date format? How to convert it?

[boudino]

Hi!

In one databse, there are dates stored as fixed point numbers (e.g. 38596.0 or 38625.0). Someone told me that this is Excel format. Could it be Excel format, or what format is it? And how can I convert it to common date time which I can read?

Thanks

[trends]

Try this query in SQL Server .Its converting ."select convert(datetime,38625.0,101)".

[boudino]

I have tried "Mark thread as resolved" and nothing has happened. So for others: it works.

[trends]

Hi ,

The number you have given is the number of days from 1900.That's it.when u give that in the convert function it converts to the present date form.

take care,
buy