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 format for display, but at least it's possible to do the inserts and updates with MySQL functions alone. [Filter fodder: SQL, query] -- Keith C. Ivey <[EMAIL PROTECTED]> Washington, DC --------------------------------------------------------------------- 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