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