Description:
It would be nice to have additional support for timezone handling in the following areas:
1)
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.
2)
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.
