MySQL Bugs: #43739: Set event date within emails to the server's locale

Bug #43739	Set event date within emails to the server's locale
Submitted:	19 Mar 2009 0:10	Modified:	21 Sep 2009 16:26
Reporter:	Mark Leith
Status:	Closed
Category:	Monitoring: Server	Severity:	S3 (Non-critical)
Version:	2.0.4.7141	OS:	Any
Assigned to:	Sloan Childers	Target Version:	2.0 maint release
Tags:	timezone, events

Description:
Events use a GMT timestamp for the event time within the email notifications. It would be
nice to give the option, or otherwise just use, the server's locale, instead of GMT.

How to repeat:
o Generate an event on a server in a US timezone
o Check the time of the event in the email that is sent

Suggested fix:
Use the server's locale, or allow the timezone locale to be settable globally and use
this.

No user is "active" when an event fires, so we'll show the server's locale plus GMT
(unless they're the same)

BUG#43739 Set event date within emails to the server's locale
- fixed to match 1.3.x branch emails which display both server and GMT timestamps
- fixed in trunk (2.1) and 2.0.x maintenance branche

Patch installed in versions => 2.1.0.1022.

Marcos Palacios writes: 
Re-opening for fixing in version 2.0.x, per Bug Council.

Sloan Childers writes: 
this should already be in the 2.0.x build

Marcos Palacios writes: 
Patch installed in versions => 2.0.6.7159

Marcos Palacios writes: 
Verified fixed in service manager build 2.0.6.7159.

An entry has been added to the 2.0.6 and 2.1.0 changelogs:

Events used a GMT timestamp for the event time within email notifications, rather than
the local time for the server generating the event.

MySQL Enterprise Monitor has been changed so that it displays the time using the server's
locale and GMT.