Use the search feature to view Kepware's repository of more than 500 Knowledge Base articles. Narrow your results or type your query into the search field below.

Alternatively, if you are unable to find a solution, we have an additional resource - our PTC eSupport Portal . If you are prompted to log into the eSupport Portal, you can use your My Kepware credentials. Need a My Kepware account? Create one here .

Search Solution Results By:
View All Solutions

Kepware Knowledge Base: Solution


MS Access Timestamp for Midnight Shows Date Only


Last Update: 11/7/2018

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.

Related Products
DataLogger, KEPServerEX, ODBC Client