What's the best way to timestamp records if records are to be exported and
then re-imported to another web server in a different time zone? Data will
be exported as comma delimited data. All of the combined records should
reflect the same instant in time, and not have the web site in California
to be timestamping data 3 hours earlier than New York. If the data were to
be merged from both sites, then records added to CA and NY at the same
instant should have the same time stamp.
The data will originate from a PHP webpage form so I was thinking of using
PHP's gmdate function to get the GMT and store that in the table. So all of
the dates and times in the database are GMT. When the user displays the
data from the table I have to format the date to a single timezone (like
Eastern Time) when the user displays the data in the browser. I don't
really care what timezone it gets displayed as, as long as sorting the
records by date show NY and CA records together if they were inserted at
the same instant.
I'd prefer to use a MySQL function to get the GMT because I don't want to
restrict data input to using just PHP. Does MySQL have a Now("GMT") option?
Or is there a better way to handle this?
TIA
Brent
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
