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