Excel date format? How to convert it?

**boudino** · October 13th, 2005, 04:40 AM

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** · October 13th, 2005, 06:02 AM

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

**boudino** · October 13th, 2005, 09:55 AM

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

**trends** · October 17th, 2005, 04:17 AM

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

Thread: Excel date format? How to convert it?

Thread Tools

Display

Excel date format? How to convert it?

Re: Excel date format? How to convert it?

Re: Excel date format? How to convert it?

Re: Excel date format? How to convert it?

Posting Permissions