Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 29th, 2007, 02:03 PM
Authorized User
 
Join Date: Jul 2004
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
Default Date conversion Issue



I have an access table that has date/times stored like the following...

39198.810243 which according to the report it generates is
4/26/07 7:26:45 PM

is this some form of a julian date?

A serial date?

How can I convert this to an actual date/time? Anything I have found gives me an error, or i'm undertain of what sort of julian date it needs to be converted to.
 
Old May 29th, 2007, 03:01 PM
Authorized User
 
Join Date: Jul 2004
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
Default


In case anyone else needs this, I Found it.

CVDATE() function in access

http://support.microsoft.com/kb/210276

Thanks!
 
Old May 30th, 2007, 06:47 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Hiya,

   www.microsoft.com has lots of articles on this issue. The first part of the date/time number (before the .) is the number of days since December 31, 1899 (I think) and the second part is the number of seconds past midnight of the day (I think).

   This is usually found in a SQL Server database, and not Access. How did you get it there?

   Did you work this out for yourself? It looks like it.





mmcdonal





Similar Threads
Thread Thread Starter Forum Replies Last Post
Database conversion issue prashantlakhlani SQL Server 2005 1 August 26th, 2006 11:46 AM
Date Conversion ashokparchuri General .NET 2 May 31st, 2005 01:26 AM
Data Conversion issue Uppa SQL Server 2000 0 February 12th, 2005 05:01 PM
Date conversion AFK SQL Language 2 February 4th, 2005 05:14 PM
Date conversion lily611 General .NET 6 December 6th, 2004 12:41 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.