Time disappears when exporting from query

[AnnaAlligood]

I am attempting to make a time-series in ArcGIS Online. I already have my four layers set up in ArcMap, and have successfully run time series on them all. The date fields are coded as dates and I've attached a screenshot for reference. The tables are made using Query Tables, as I have somewhere in the vicinity of 1500 records that needed matching to time stamps. Here's my problem - whenever I export the data to a shapefile, to fold it into a .zip for Online, the time stamps are shortened to just the date. Since all my data takes place on the same day, but at different times, I very much need those. Can anyone let me know what I am doing wrong? Why are my times disappearing when exporting? At first I thought it was a character # issue,  but shortening didn't help with anything.

Thanks in advance!!

[KenBuja · Accepted solution]

Shapefiles Date fields can only hold date information, not time. From the documentation:

However, for coverages and shapefiles, the time portion is truncated from the datetime value. For example, the datetime 2002-08-20 12:00:00 PM is stored in a coverage or shapefile as 2002-08-20.

[AnnaAlligood]

Thank you, that was a silly oversight!

I now have another problem - When importing, the time zone is wrong. I first did it in Pacific, then realized ArcGIS operates in UTC. I changed my time-enabled layer in ArcMap to UTC+adjusted for DST, but my time stamps are still off. Am I missing something? Not changing the right thing?

[KenBuja]

Are the features' time in UTC or Pacific? You should set them to the time zone they were recorded in. Otherwise, AGOL will assume they are UTC.

And don't forget to mark the question as answered.

[AnnaAlligood]

They were recorded in pacific. 

Ive tried with both and both end up imported as the wrong time. 

[WilliamJameson]

I guess I am dense, but restating the problem is not a solution. Referring to esri documentation about dates is also not a solution.

ArcGIS has dropped the ball on this. I have date-time in a CSV file. when converted to a shapefile the time is lost. I have over 375,000 records, so retyping anything is not an option. turns out too that converting my CSV file date-time column to text does not help either because arcMap sees that text column and identifies it as date and drops the time anyway. I cannot see a solution.

Why would anyone need 375,000+ records? ships crossing an ocean, or airplanes flying over a nation for two weeks are two reasons.

[RaineyBarton]

Has anyone figured out a solution to this problem? I agree with WilliamJameson that stating the problem with respect to the shapefile date field is not a solution. If you have a layer in AGOL that has both date and time in the Date field, how then do you get it in a format that can be exported and retain time?