Article - CS333167
MS Access Timestamp for Midnight Shows Date Only
Modified: 02-Nov-2020
Applies To
- Kepware Server (formerly KEPServerEX) 5.19.467.0 to 6.8
- ThingWorx Kepware Server (legacy) 8.0 to 8.4
Description
MS Access stores date and time internally as a double precision floating point number ( xxxx.yyyy) . At midnight, yyyy is zero and is not displayed by the Access UI; however, time comparison SQL arithmetic using a midnight date and time will work correctly because no data is actually missing.
This is a printer-friendly version of Article 333167 and may be out of date. For the latest version click CS333167