[aclug-L] mysql, timestamps and timezones (oh my)
[Top] [All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index] [Thread Index]
question for any of you that are good with databases and understand
#$^%#$% timezone stuff ...
working on an app that tracks hours worked (and much, much more) and am
needing to add timezone support ... when storing events, i have a table
that is (basically) like this:
| eventLogID [PK] |
| usersID |
| timeIn |
| timeOut |
now, what would be the best storage method for timeIn/timeOut? i have
been using the mysql DATETIME data type ('YmdHis'), but i'm nervous
about what happens when you have employees in a timezone different than
the one the server is in ... (ie: we have 2 employees in florida, but
the server is here in KS) ... suggestions?
"...deflated ... and jaded ...
i hate it when you call ... (which isn't at all)..."
'Thanks, That Was Fun' - Barenaked Ladies
-- This is the discussion@xxxxxxxxx list. To unsubscribe,
- [aclug-L] mysql, timestamps and timezones (oh my),
Jesse Kaufman <=