sparkfun / phant

the data logging engine behind data.sparkfun.com
700 stars 98 forks source link

Timestamp adjustment ? #75

Closed Serasidis closed 10 years ago

Serasidis commented 10 years ago

Hello. I live in Greece and the local time is +3 hours than the UTC/GMT time (this is the time format stores by default the phant data server). Is that possible to adjust the logs timestamp to write the local time, not the UTC/GMT time ?

I want to send some data from arduino (with ethernet shield) and it would be more easy for me if I could send an additional data, for example "adjust" or "adj" with value +3 to adjust the log timestamp to UTC + 3 hours.

Thank you

toddtreece commented 10 years ago

@Serasidis I think the server should always use UTC, but I could see why you would like this for data output. I'll try to figure something out so you can request data using the appropriate adjustment.

nseidle commented 10 years ago

I do this on the device side on my Weather Station. I wanted to see when the data was getting pushed according to local time. You can see 'measurement time' on my feed. The Imp is capable of getting UTC from the net and then I do a conversion to local time (including daylight savings). I think it's best to keep the server timestamp UTC and let the user adjust on their own.

toddtreece commented 10 years ago

@Serasidis The additions in #91 allow you to use the IANA Time Zone Database name format to convert the UTC timestamp field to your local time. You can request the conversion by adding ?timezone=VALUE to the output URL.

Serasidis commented 10 years ago

@toddtreece Thank you!