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
Brent,
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
Two more possibilities:
1. Set your MySQL server to use GMT for everything (that is, in the
OS, not in MySQL).
2. Store all times as Unix time (seconds since 1970) -- the
UNIX_TIMESTAMP() function can be useful for this.
Either solution still has the problem of converting to another