Complete.Org: Mailing Lists: Archives: discussion: April 2004:
[aclug-L] mysql, timestamps and timezones (oh my)

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

[Top] [All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index] [Thread Index]
To: discussion@xxxxxxxxx
Subject: [aclug-L] mysql, timestamps and timezones (oh my)
From: Jesse Kaufman <glandix@xxxxxxxxxxxxx>
Date: Mon, 12 Apr 2004 13:16:56 -0500
Reply-to: discussion@xxxxxxxxx

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,

[Prev in Thread] Current Thread [Next in Thread]