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:	18 Mar 2009 23:10	Modified:	21 Sep 2009 14:26
Reporter:	Mark Leith	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Server	Severity:	S3 (Non-critical)
Version:	2.0.4.7141	OS:	Any
Assigned to:	Sloan Childers	CPU Architecture:	Any
Tags:	events, timezone

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.