Page 1 of 1
Time Zone issue
Posted: Sat Aug 11, 2012 2:36 am
by abernat
For my own reasons, I'd like to have direct access to the Time Zone. I see that it is not one of the fields that can be exported (it's not in the clickable list) and I do not know how to read it directly using SQLite.
Can you let me know how?
Thanks,
Andy
Re: Time Zone issue
Posted: Sat Aug 11, 2012 7:51 am
by abernat
I'd be happy with an SQLite query that would pull up the time zone!
Andy
Re: Time Zone issue
Posted: Sat Aug 11, 2012 8:36 am
by nick
You should not access the sqlite database directly - it is managed by an apple framework and subject to change. The information is not available via sqlite anyway.
Why do you need it? The output time should be in the correct timezone, and other than that it's only used to ensure changing your actual mac's timezone does not cause issues. It is intended as an internal implementation detail.
Re: Time Zone issue
Posted: Sat Aug 11, 2012 9:49 pm
by abernat
I have a legacy way of keeping track of dives and am using MacDive to do the downloading. I guess that pre-time zone the times in the database were the local time of the dive while now they are GMT and the Time Zone is used to calculate the correct local time. This throws my legacy approach off unless I correct.
Andy