Thursday, 31 August 2017

arcgis desktop - Display full date-time, even when the time is 00:00:00


I have date fields in Oracle tables. When I view the data in the attribute window, the dates are displayed like this:



  1. 1/1/2017


  2. 1/2/2017 3:50:28 PM


As demonstrated in #1, ArcMap doesn't show the time portion of the date if it is 00:00:00 (even though it technically exists in the underlying table).


Is there a way to force ArcMap to show the full date-time of date fields in the attribute table, even if the time component is 00:00:00?


Example:



  1. 1/1/2017 00:00:00 <<<---

  2. 1/2/2017 3:50:28 PM


I've poked around the documentation, but haven't found anything specific to this exact issue.




The reason I ask is:


I'm doing some intensive testing on views based on temporal tables. I'm doing a lot of querying and editing of the time portion of date fields. It would be helpful to see the time portion of the dates, even when the time is 00:00:00.




No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...