Bug #6742 No way to store Timezone toogether with datetime?
Submitted: 21 Nov 2004 22:17 Modified: 22 Nov 2004 11:05
Reporter: Geert Vanderkelen Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version:4.x OS:Any
Assigned to: CPU Architecture:Any
Triage: Triaged: D5 (Feature request)

[21 Nov 2004 22:17] Geert Vanderkelen
Description:
Hey,

There seems to be no way to store the timezone toogether with a datetime field. Setting the timezone per session is a hack and a bit dangerous imho..

Maybe we need something like in PostgreSQL, like 'datetimezone'? A datetime containing timezone information?
Or I just missed something?

Thanks,

Geert

How to repeat:
Not a bug.. Not a feature, it's a request :)
[22 Nov 2004 11:05] Sergei Golubchik
Yes, we plan to add standard TIMESTAMP WITH TIME ZONE type soon
[28 May 2009 21:42] Shawn Green
As it turns out, this datatype would help many different industries.
[10 Sep 2009 7:34] Sascha Ziemann
Even 5 years later not available?