wsharba / opendatakit

Automatically exported from code.google.com/p/opendatakit
0 stars 1 forks source link

timestamp conflict between UTC and local time #980

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. Recording survey start time.
2. Downloading .csv records from Aggregate or Briefcase
3.

What is the expected output? What do you see instead?

We expect the meta:start_time field in UTC. What actually happens is that the 
time of the day follows UTC while the date component follows the local time 
zone. Our project was conducted in PST during daylight savings, so our local 
time zone was UTC -8. 

At 24:00 each day, the hh:mm:ss AM/PM part of the timestamp rolls over 
normally. But the DD/MM/YYYY part stays the same until the local date rolls 
over. This timestamps from 00:00 - 08:00 UTC to be backdated by one day.

What version of the product are you using? On what operating system?

ODK Collectt 1.4 (1038) 
ODK Aggregate (deployed on Google App Engine)
ODK Briefcase Version ??? (sorry, we are a big team, I will look into the 
version ##)

Please provide any additional information below.

The plots in the attached Excel file do a good job of illustrating the behavior.

Original issue reported on code.google.com by TwoWheel...@gmail.com on 11 Mar 2014 at 6:45

Attachments: