Bug #11145 Minor suggections for additional TimeZone support
Submitted: 7 Jun 2005 17:02 Modified: 15 Dec 2010 7:34
Reporter: Darryl Miles Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: General Severity:S4 (Feature request)
Version:4.0/4.1 OS:Any (All)
Assigned to: CPU Architecture:Any

[7 Jun 2005 17:02] Darryl Miles
It would be nice to have additional support for timezone handling in the following areas:


A new server variable that is called "timezone_offset_seconds" this is just a way to ask the server what its current timezone working offset is in seconds.  This would be a integral value that is +ve or -ve figure, +0100 would be 3600, -0400 would be -14400. 

Maybe seconds are not necessary or you can think some better way to mathmatically represent the offset value.  Maybe this could be minutes, maybe a string format "+0100" , just anything so long as it can be mathmatically used to make adjustment.


New "%" escapes to DATE_FORMAT() to print the timezone offset in human form "GMT, CET, PST, etc..." and in mathmatical format "+0000, +0100, +0200, -0400, etc..." this would be the timezone that related to the date being processing.  For example if you decide to have a new DATETIMEZONE type it would be the variable associated TZ value otherwise it would be the servers TZ value for that date.

I suggest to follow POSIX strftime() syntax using "%z" and "%Z" providing they are not already in use, just to save us programmers have to relearn again completely.

How to repeat:
Feature requests please consider.
[15 Dec 2010 7:34] Valeriy Kravchuk
Thank you for the feature request.