Frequently asked question

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

Last Published: April 25, 2020


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.
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

  • ArcMap

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options