| Bug #50672 | add a [DEFAULT] TIMEZONE [=] time_zone option to CREATE DATABASE | ||
|---|---|---|---|
| Submitted: | 27 Jan 2010 18:04 | ||
| Reporter: | Matthew Lord | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S4 (Feature request) |
| Version: | 5.5 | OS: | Any |
| Assigned to: | Geir Høydalsvik | CPU Architecture: | Any |
| Tags: | create database, time_zone, timezone | ||
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.044 sec. using MySQL 8.4.5-u4-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.
© 2025, Oracle Corporation and/or its affiliates
Description: It would be very helpful to have different time zones for different databases. This would be particularly helpful for hosting providers who have customers in different time zones while their data is in the same mysqld instance. We could add this support using the CREATE DATABASE statement: CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [DEFAULT] CHARACTER SET [=] charset_name [DEFAULT] COLLATE [=] collation_name [DEFAULT] TIMEZONE [=] time_zone How to repeat: n/a Suggested fix: n/a