Jumped the gun there and didn't finish my post.
I was going to observe that this result is clearly not desired (just calling "11:42" an Eastern time).
This has to be such a common issue, but I haven't been able to find a solution. Well, I found this, but it's for ColdFusion, and I really think I must just be missing something, because there must be an easier way to do this. Thanks for any thoughts!
Update: Based on this topic on Stack Overflow, I tried changing the value in the insert from "DATETIME('NOW')" with a parameter:
stmt.parameters[":created"] = new window.runtime.Date();
(Aside: it's kind of annoying that AIR does not support JS dates, I'd like to see that change.)
Anyway, this still doesn't solve the original problem. It works just like using DATETIME('NOW','localtime'). If the value goes in at 1:54pm PST, and I change the timezone to EST and read the value, it displays as "1:54pm EST", when I would expect it to be "4:54pm EST".
Any advice is appreciated. Thanks!
Well, it doesn't look like an answer is coming anytime soon. For the record, in case anyone has the same question, my workaround (and it seems others have gone this route as well) was to change my DATE columns to INT, and just record the timestamp:
stmt.parameters[":created"] = new Date().getTime();
Now the value is timezone neutral, and I can display the proper value adjusted for the local timezone. It feels dirty to do it this way, but it works perfectly.