Gentlemen, Thank you for your informative coverage regarding the captioned. According to your recommendations I've created a separate location table which contains time zone difference in (+/-) minutes. As per the server, my assumptions is that it's located somewhere in California, U.S. (my hosting provider is using EV1). My question is, how to write bulletproof code so that my server code (in PHP) would always store date/time in GMT?
Also, how do I tackle DST, and automatically adjust incoming time for daylight saving changes. Appreciate your input and help. Thanks! Hassan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]