[aclug-L] mysql, timestamps and timezones (oh my)

[Jesse Kaufman <glandix@xxxxxxxxxxxxx>]

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?  

thanks,
jesse

-- 
"...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,
visit http://www.complete.org/cgi-bin/listargate-aclug.cgi