Depends on the language you are writing in, and the level of your programming skills.
If your users/guests have database entries, it would be a rather trivial task to set their timezone in a column in the database, then write your app to calculate their local time based on the offset from GMT. You would either have to rely on the user to use a form or image map of some sort to select a timezone (ala Red Hat's installer), or devise a way to ready the clock on their local machine. IMHO, this is a programming problem as opposed to a MySQL database issue. ----- Original Message ----- From: "Maxim Vysotskiy" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 28, 2002 7:14 PM Subject: Re[2]: client dependent timezone Hello Gerald, But how people build web-applications then ? How can you use web-hosting in GMT+1 if web-application will be in use in GMT+5 for example? Have anybody an experience of resolving this problem (without embedding this functionality to backend app, because backend app is allready contains ~20000 lines of code, and somewhere near to 1000 queries). If someone knows how to play this around - please help! Friday, March 29, 2002, 3:02:57 AM, you wrote: GRJ> Per client? Per database? The only timezone setting in the MySQL manual is GRJ> for the server (tz), and permits you to set it to your local timezone so it GRJ> does not return values in GMT. GRJ> If you want clients to have different timezones, perhaps you should write GRJ> that capabilty into your front-end application. GRJ> Gerald Jensen GRJ> ----- Original Message ----- GRJ> From: "Maxim Vysotskiy" <[EMAIL PROTECTED]> GRJ> To: <[EMAIL PROTECTED]> GRJ> Sent: Thursday, March 28, 2002 6:46 PM GRJ> Subject: client dependent timezone GRJ> Hello mysql, GRJ> So nobody here (even at MySQL AB) knows how to set a timezone for a GRJ> MySQL client ? Not for whole server but per client? (or maybe for GRJ> database???) GRJ> I already posted this question here few days ago - and didn't get any GRJ> reply. GRJ> Please! Somebody help! GRJ> -- GRJ> Best regards, GRJ> Maxim mailto:[EMAIL PROTECTED] -- Best regards, Maxim mailto:[EMAIL PROTECTED] --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php