Time Storage?
-
I need to know how the times are stored for events as we are directly querying the db tables for events for another page we put up.
I (incorrectly) assumed they were stored as timestamps (UTC) but apparently not. It appears that they are stored in Mountain Time (everything in the db is 2 hrs behind us and we’re on Eastern Time).
The calendar works fine, but our direct querying is pulling in events from the wrong days as a result of how they’re stored in the DB.
Yes, I know we’re probably not supposed to do this, but it’s a necessity right now for the client. I’d just like to know how I can convert the start and end times in the ailec_events table correctly.
There’s some urgency for this, so if anyone other than the developer has figured this out, please share.
- The topic ‘Time Storage?’ is closed to new replies.
