DBI date / time components are stored as a double-precision, floating-point number (up to 15 decimal places). The integer portion of the double-precision number represents the date; the decimal portion represents the time. A date value of 0 represents December 30, 1899 or January 1, 1900 depending on your development platform. The time values range from .0 (00:00:00) to .99999 (23:59:59). The numeric value represents a fraction of one day. To assign date and time values to a component the developer must convert the date value or the time value to a long integer and then assign it to the component. If a date value is assigned to the component, many development languages will coerce the value into a string.
| For Visual Basic and Access developers |
| 'Create a variable of type date |
| Dim datMyDate As Date |
| 'Assign a "standard" date value to the variable |
| datMyDate = "5 / 5 / 2003" |
| 'When adding the date to the ctList control, convert the variable to a long integer |
| Me.ctList1.AddItem CLng(datMyDate) |
| For Visual FoxPro developers |
| datMyDate = STR(DATE() - CTOD("01/01/1900")) |
| nindex = thisform.olecontrol1.lvaddItem (datMyDate) |
For additional information on this topic, please navigate to knowledge base article 130514 available at the MSDN website.