Hmmm, two timezone issues in one day. Did you try using UTC tz in your data instead of -8?
There are two different questions: 1) What TZ is Exhibit/Timeline in. This determines "when" a date's mark is shown on the band. Eg is "Start of Monday" at time 2009-06-21 00:00:00T00 or 2009-06-21 00:00:00T-08 2) What TZ is the data in once it is parsed by the Timeline library. Unless the two match, the data won't line up with the glyphs. Check that any settings for your Exhibit or Timeline use 0 as the tz. Eg in the create band parameters. Do all of your date/times come from the one data source? Hope this helped, Larry ________________________________ From: mleden <[email protected]> To: SIMILE Widgets <[email protected]> Sent: Tuesday, March 17, 2009 12:40:14 PM Subject: Exhibit, timezones, and mySQL DATETIME Hi, I'm having some trouble understanding exactly what I need to do to format date/time data to "represent itself correctly" using the local timezone. Here's my setup: 1. I have a mySQL instance that stores my data including two columns defined as DATETIME 2. I run a query to grab and format the data as a JSON file readable by Exhibit 3. I have a Timeline view that renders the JSON file including the two columns defined as DATETIME Everything works fine EXCEPT that the values from the DATETIME columns are not aligned with the begin and end ticks on the Timeline. I assume that this is to do with a "timezone mismatch". I'm not doing anything special with the DATETIME data during input in the database. For example, the value of '2009-06-21 00:00:00' represents "the start" of June 21st 2009. From what I understand, without any further "data transitions", Exhibit would assume this to be UTC. Therefore, on returning the value in the query noted earlier I have tried to "transition the value" by using a mask with an offset (for Pacific Time) on the mySQL DATETIME value to give me "2009-06-21T00:00-08" in the JSON file. However, this still renders "misaligned" in the Timeline, as noted previously. Any thoughts on what I'm doing wrong? Appreciate any suggestions. -Mark --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SIMILE Widgets" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/simile-widgets?hl=en -~----------~----~----~----~------~----~------~--~---
