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

相关信息
Article ID: 42023
Software:
ArcGIS for Desktop Advanced 10.1, 10.2, 10.2.1
ArcGIS for Desktop Standard 10.1, 10.2, 10.2.1
ArcGIS for Desktop Basic 10.1, 10.2, 10.2.1
Platforms:
Windows XP, Vista, Windows 7, Windows 8

问题描述
Why does ArcMap not display 12:00:00 AM in a date field?
已邀请:

易智瑞技术支持

赞同来自:

解决方案
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 a user manually inputs 12:00 AM 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

创建及修改时间
Created: 12/26/2013

Last Modified: 2/18/2014
原文链接
http://support.esri.com/en/kno ... 42023

要回复问题请先登录注册