AnsweredAssumed Answered

Time in a field SDE best practice

Question asked by fallingdog on Apr 20, 2016
Latest reply on Apr 22, 2016 by fallingdog

I have date and time data in two field in a csv file that I will be appending to a SDE feature class. I have created two fields in the target feature class for the data--date and time--and set the data type to date for both. One goal we have is for the data to be sortable by the time field. I have tested it in ArcGIS 10.1 and it looks like it is working fine.  However, when I look with a database tool I see that the time records have a weird date added to them, which I am guessing is just a esri place holder for the date.

 

Screeshot from TOAD

So, is this the best practice for storing time? We are on: SDE 10.1 oracle11g

 

Thanks,

 

Forest

Outcomes