FAQ: Why Does ArcMap Not Display 12:00:00 AM in a Date Field?

Answer

12:00 AM is the internal default time set by a geodatabase when there is no user input for time in a date field. If 12:00 AM is manually input into a date field, ArcGIS handles it as if it were not entered since it matches the default value and is not displayed in the date field. This is by design.

Note:
A geodatabase formats the date as 'datetime yyyy-mm-dd hh:mm:ss AM or PM'. By default, when a user does not input a time, the date field value is set to 12:00 AM. Similarly, when a user does not input a date, the date field value is set to December 30, 1899.

For more information, please refer to the Dates and time section in the ArcGIS Resource Center: SQL reference for query expressions used in ArcGIS

Article ID:000011961

Software:

ArcMap

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

ArcGIS Help: Fundamentals of date fields
ArcGIS Help: Field configurations

Why does ArcMap not display 12:00:00 AM in a date field?

Answer

Related Information

Discover more on this topic