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:
None 
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
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.
[15 Dec 2010 7:34] Valeriy Kravchuk
Thank you for the feature request.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.