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:
Category:MySQL Server: Data Types Severity:S4 (Feature request)
Version:4.x OS:Any
Assigned to: CPU Architecture:Any

[21 Nov 2004 22:17] Geert Vanderkelen

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?



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] MySQL Verification Team
As it turns out, this datatype would help many different industries.
[10 Sep 2009 7:34] Sascha Ziemann
Even 5 years later not available?
[14 Jan 2020 0:13] Mark Guinness
15 years and counting.  WL#10828 was added to release 8.0.19 that's equivalent to timestamptz in PostgreSQL, but not comparable to datetimeoffset in SQL Server.