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 -~----------~----~----~----~------~----~------~--~---
