MarkTTU
Lifetime Supporting Member
I've got an application where a date/time stamp stored in a database needs to be pulled from the database and displayed on a C-More. I've got the function working to pull the number from the database into a DL06, but I'm not real sure how to handle the number I get back from the database because Microsoft stores date/time stamps as a real number with 1/1/1900 being 1 and counting each day from there; fractions of days are hours, minutes, seconds... From the Access help file:
----------------------------
About dates and date systems
Microsoft Access stores dates as sequential numbers which are called serial values. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. Access stores times as decimal fractions because time is considered a portion of a day.
--------------------------------------
OK so given all that does anyone have any ideas on how to convert this number back into a intelligible date and time I can display on the C-More?
Thanks.
----------------------------
About dates and date systems
Microsoft Access stores dates as sequential numbers which are called serial values. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. Access stores times as decimal fractions because time is considered a portion of a day.
--------------------------------------
OK so given all that does anyone have any ideas on how to convert this number back into a intelligible date and time I can display on the C-More?
Thanks.