Timezone conversion routines
/*
Copyright (C) 2002 MySQL AB
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
import java.sql.Time;
import java.sql.Timestamp;
import java.util.Calendar;
import java.util.GregorianCalendar;
import java.util.HashMap;
import java.util.TimeZone;
/**
* Timezone conversion routines
*
* @author Mark Matthews
*/
public class TimeUtil
{
//~ Instance/static variables .............................................
static TimeZone GMT_TIMEZONE = TimeZone.getTimeZone("GMT");
static final HashMap TIMEZONE_MAPPINGS;
//~ Initializers ..........................................................
static {
TIMEZONE_MAPPINGS = new HashMap(175);
//
// Windows Mappings
//
TIMEZONE_MAPPINGS.put("Romance", "Europe/Paris");
TIMEZONE_MAPPINGS.put("Romance Standard Time", "Europe/Paris");
TIMEZONE_MAPPINGS.put("Warsaw", "Europe/Warsaw");
TIMEZONE_MAPPINGS.put("Central Europe", "Europe/Prague");
TIMEZONE_MAPPINGS.put("Central Europe Standard Time", "Europe/Prague");
TIMEZONE_MAPPINGS.put("Prague Bratislava", "Europe/Prague");
TIMEZONE_MAPPINGS.put("W. Central Africa Standard Time",
"Africa/Luanda");
TIMEZONE_MAPPINGS.put("FLE", "Europe/Helsinki");
TIMEZONE_MAPPINGS.put("FLE Standard Time", "Europe/Helsinki");
TIMEZONE_MAPPINGS.put("GFT", "Europe/Athens");
TIMEZONE_MAPPINGS.put("GFT Standard Time", "Europe/Athens");
TIMEZONE_MAPPINGS.put("GTB", "Europe/Athens");
TIMEZONE_MAPPINGS.put("GTB Standard Time", "Europe/Athens");
TIMEZONE_MAPPINGS.put("Israel", "Asia/Jerusalem");
TIMEZONE_MAPPINGS.put("Israel Standard Time", "Asia/Jerusalem");
TIMEZONE_MAPPINGS.put("Arab", "Asia/Riyadh");
TIMEZONE_MAPPINGS.put("Arab Standard Time", "Asia/Riyadh");
TIMEZONE_MAPPINGS.put("Arabic Standard Time", "Asia/Baghdad");
TIMEZONE_MAPPINGS.put("E. Africa", "Africa/Nairobi");
TIMEZONE_MAPPINGS.put("E. Africa Standard Time", "Africa/Nairobi");
TIMEZONE_MAPPINGS.put("Saudi Arabia", "Asia/Riyadh");
TIMEZONE_MAPPINGS.put("Saudi Arabia Standard Time", "Asia/Riyadh");
TIMEZONE_MAPPINGS.put("Iran", "Asia/Tehran");
TIMEZONE_MAPPINGS.put("Iran Standard Time", "Asia/Tehran");
TIMEZONE_MAPPINGS.put("Afghanistan", "Asia/Kabul");
TIMEZONE_MAPPINGS.put("Afghanistan Standard Time", "Asia/Kabul");
TIMEZONE_MAPPINGS.put("India", "Asia/Calcutta");
TIMEZONE_MAPPINGS.put("India Standard Time", "Asia/Calcutta");
TIMEZONE_MAPPINGS.put("Myanmar Standard Time", "Asia/Rangoon");
TIMEZONE_MAPPINGS.put("Nepal Standard Time", "Asia/Katmandu");
TIMEZONE_MAPPINGS.put("Sri Lanka", "Asia/Colombo");
TIMEZONE_MAPPINGS.put("Sri Lanka Standard Time", "Asia/Colombo");
TIMEZONE_MAPPINGS.put("Beijing", "Asia/Shanghai");
TIMEZONE_MAPPINGS.put("China", "Asia/Shanghai");
TIMEZONE_MAPPINGS.put("China Standard Time", "Asia/Shanghai");
TIMEZONE_MAPPINGS.put("AUS Central", "Australia/Darwin");
TIMEZONE_MAPPINGS.put("AUS Central Standard Time", "Australia/Darwin");
TIMEZONE_MAPPINGS.put("Cen. Australia", "Australia/Adelaide");
TIMEZONE_MAPPINGS.put("Cen. Australia Standard Time",
"Australia/Adelaide");
TIMEZONE_MAPPINGS.put("Vladivostok", "Asia/Vladivostok");
TIMEZONE_MAPPINGS.put("Vladivostok Standard Time", "Asia/Vladivostok");
TIMEZONE_MAPPINGS.put("West Pacific", "Pacific/Guam");
TIMEZONE_MAPPINGS.put("West Pacific Standard Time", "Pacific/Guam");
TIMEZONE_MAPPINGS.put("E. South America", "America/Sao_Paulo");
TIMEZONE_MAPPINGS.put("E. South America Standard Time",
"America/Sao_Paulo");
TIMEZONE_MAPPINGS.put("Greenland Standard Time", "America/Godthab");
TIMEZONE_MAPPINGS.put("Newfoundland", "America/St_Johns");
TIMEZONE_MAPPINGS.put("Newfoundland Standard Time", "America/St_Johns");
TIMEZONE_MAPPINGS.put("Pacific SA", "America/Caracas");
TIMEZONE_MAPPINGS.put("Pacific SA Standard Time", "America/Caracas");
TIMEZONE_MAPPINGS.put("SA Western", "America/Caracas");
TIMEZONE_MAPPINGS.put("SA Western Standard Time", "America/Caracas");
TIMEZONE_MAPPINGS.put("SA Pacific", "America/Bogota");
TIMEZONE_MAPPINGS.put("SA Pacific Standard Time", "America/Bogota");
TIMEZONE_MAPPINGS.put("US Eastern", "America/Indianapolis");
TIMEZONE_MAPPINGS.put("US Eastern Standard Time",
"America/Indianapolis");
TIMEZONE_MAPPINGS.put("Central America Standard Time",
"America/Regina");
TIMEZONE_MAPPINGS.put("Mexico", "America/Mexico_City");
TIMEZONE_MAPPINGS.put("Mexico Standard Time", "America/Mexico_City");
TIMEZONE_MAPPINGS.put("Canada Central", "America/Regina");
TIMEZONE_MAPPINGS.put("Canada Central Standard Time", "America/Regina");
TIMEZONE_MAPPINGS.put("US Mountain", "America/Phoenix");
TIMEZONE_MAPPINGS.put("US Mountain Standard Time", "America/Phoenix");
TIMEZONE_MAPPINGS.put("GMT", "Europe/London");
TIMEZONE_MAPPINGS.put("GMT Standard Time", "Europe/London");
TIMEZONE_MAPPINGS.put("Ekaterinburg", "Asia/Yekaterinburg");
TIMEZONE_MAPPINGS.put("Ekaterinburg Standard Time",
"Asia/Yekaterinburg");
TIMEZONE_MAPPINGS.put("West Asia", "Asia/Karachi");
TIMEZONE_MAPPINGS.put("West Asia Standard Time", "Asia/Karachi");
TIMEZONE_MAPPINGS.put("Central Asia", "Asia/Dhaka");
TIMEZONE_MAPPINGS.put("Central Asia Standard Time", "Asia/Dhaka");
TIMEZONE_MAPPINGS.put("N. Central Asia Standard Time",
"Asia/Novosibirsk");
TIMEZONE_MAPPINGS.put("Bangkok", "Asia/Bangkok");
TIMEZONE_MAPPINGS.put("Bangkok Standard Time", "Asia/Bangkok");
TIMEZONE_MAPPINGS.put("North Asia Standard Time", "Asia/Krasnoyarsk");
TIMEZONE_MAPPINGS.put("SE Asia", "Asia/Bangkok");
TIMEZONE_MAPPINGS.put("SE Asia Standard Time", "Asia/Bangkok");
TIMEZONE_MAPPINGS.put("North Asia East Standard Time",
"Asia/Ulaanbaatar");
TIMEZONE_MAPPINGS.put("Singapore", "Asia/Singapore");
TIMEZONE_MAPPINGS.put("Singapore Standard Time", "Asia/Singapore");
TIMEZONE_MAPPINGS.put("Taipei", "Asia/Taipei");
TIMEZONE_MAPPINGS.put("Taipei Standard Time", "Asia/Taipei");
TIMEZONE_MAPPINGS.put("W. Australia", "Australia/Perth");
TIMEZONE_MAPPINGS.put("W. Australia Standard Time", "Australia/Perth");
TIMEZONE_MAPPINGS.put("Korea", "Asia/Seoul");
TIMEZONE_MAPPINGS.put("Korea Standard Time", "Asia/Seoul");
TIMEZONE_MAPPINGS.put("Tokyo", "Asia/Tokyo");
TIMEZONE_MAPPINGS.put("Tokyo Standard Time", "Asia/Tokyo");
TIMEZONE_MAPPINGS.put("Yakutsk", "Asia/Yakutsk");
TIMEZONE_MAPPINGS.put("Yakutsk Standard Time", "Asia/Yakutsk");
TIMEZONE_MAPPINGS.put("Central European", "Europe/Belgrade");
TIMEZONE_MAPPINGS.put("Central European Standard Time",
"Europe/Belgrade");
TIMEZONE_MAPPINGS.put("W. Europe", "Europe/Berlin");
TIMEZONE_MAPPINGS.put("W. Europe Standard Time", "Europe/Berlin");
TIMEZONE_MAPPINGS.put("Tasmania", "Australia/Hobart");
TIMEZONE_MAPPINGS.put("Tasmania Standard Time", "Australia/Hobart");
TIMEZONE_MAPPINGS.put("AUS Eastern", "Australia/Sydney");
TIMEZONE_MAPPINGS.put("AUS Eastern Standard Time", "Australia/Sydney");
TIMEZONE_MAPPINGS.put("E. Australia", "Australia/Brisbane");
TIMEZONE_MAPPINGS.put("E. Australia Standard Time",
"Australia/Brisbane");
TIMEZONE_MAPPINGS.put("Sydney Standard Time", "Australia/Sydney");
TIMEZONE_MAPPINGS.put("Central Pacific", "Pacific/Guadalcanal");
TIMEZONE_MAPPINGS.put("Central Pacific Standard Time",
"Pacific/Guadalcanal");
TIMEZONE_MAPPINGS.put("Dateline", "Pacific/Majuro");
TIMEZONE_MAPPINGS.put("Dateline Standard Time", "Pacific/Majuro");
TIMEZONE_MAPPINGS.put("Fiji", "Pacific/Fiji");
TIMEZONE_MAPPINGS.put("Fiji Standard Time", "Pacific/Fiji");
TIMEZONE_MAPPINGS.put("Samoa", "Pacific/Apia");
TIMEZONE_MAPPINGS.put("Samoa Standard Time", "Pacific/Apia");
TIMEZONE_MAPPINGS.put("Hawaiian", "Pacific/Honolulu");
TIMEZONE_MAPPINGS.put("Hawaiian Standard Time", "Pacific/Honolulu");
TIMEZONE_MAPPINGS.put("Alaskan", "America/Anchorage");
TIMEZONE_MAPPINGS.put("Alaskan Standard Time", "America/Anchorage");
TIMEZONE_MAPPINGS.put("Pacific", "America/Los_Angeles");
TIMEZONE_MAPPINGS.put("Pacific Standard Time", "America/Los_Angeles");
TIMEZONE_MAPPINGS.put("Mexico Standard Time 2", "America/Chihuahua");
TIMEZONE_MAPPINGS.put("Mountain", "America/Denver");
TIMEZONE_MAPPINGS.put("Mountain Standard Time", "America/Denver");
TIMEZONE_MAPPINGS.put("Central", "America/Chicago");
TIMEZONE_MAPPINGS.put("Central Standard Time", "America/Chicago");
TIMEZONE_MAPPINGS.put("Eastern", "America/New_York");
TIMEZONE_MAPPINGS.put("Eastern Standard Time", "America/New_York");
TIMEZONE_MAPPINGS.put("E. Europe", "Europe/Bucharest");
TIMEZONE_MAPPINGS.put("E. Europe Standard Time", "Europe/Bucharest");
TIMEZONE_MAPPINGS.put("Egypt", "Africa/Cairo");
TIMEZONE_MAPPINGS.put("Egypt Standard Time", "Africa/Cairo");
TIMEZONE_MAPPINGS.put("South Africa", "Africa/Harare");
TIMEZONE_MAPPINGS.put("South Africa Standard Time", "Africa/Harare");
TIMEZONE_MAPPINGS.put("Atlantic", "America/Halifax");
TIMEZONE_MAPPINGS.put("Atlantic Standard Time", "America/Halifax");
TIMEZONE_MAPPINGS.put("SA Eastern", "America/Buenos_Aires");
TIMEZONE_MAPPINGS.put("SA Eastern Standard Time",
"America/Buenos_Aires");
TIMEZONE_MAPPINGS.put("Mid-Atlantic", "Atlantic/South_Georgia");
TIMEZONE_MAPPINGS.put("Mid-Atlantic Standard Time",
"Atlantic/South_Georgia");
TIMEZONE_MAPPINGS.put("Azores", "Atlantic/Azores");
TIMEZONE_MAPPINGS.put("Azores Standard Time", "Atlantic/Azores");
TIMEZONE_MAPPINGS.put("Cape Verde Standard Time",
"Atlantic/Cape_Verde");
TIMEZONE_MAPPINGS.put("Russian", "Europe/Moscow");
TIMEZONE_MAPPINGS.put("Russian Standard Time", "Europe/Moscow");
TIMEZONE_MAPPINGS.put("New Zealand", "Pacific/Auckland");
TIMEZONE_MAPPINGS.put("New Zealand Standard Time", "Pacific/Auckland");
TIMEZONE_MAPPINGS.put("Tonga Standard Time", "Pacific/Tongatapu");
TIMEZONE_MAPPINGS.put("Arabian", "Asia/Muscat");
TIMEZONE_MAPPINGS.put("Arabian Standard Time", "Asia/Muscat");
TIMEZONE_MAPPINGS.put("Caucasus", "Asia/Tbilisi");
TIMEZONE_MAPPINGS.put("Caucasus Standard Time", "Asia/Tbilisi");
TIMEZONE_MAPPINGS.put("GMT Standard Time", "GMT");
TIMEZONE_MAPPINGS.put("Greenwich", "GMT");
TIMEZONE_MAPPINGS.put("Greenwich Standard Time", "GMT");
}
//~ Methods ...............................................................
public static String getCanoncialTimezone(String timezoneStr)
{
if (timezoneStr == null) {
return null;
}
timezoneStr = timezoneStr.trim();
// Fix windows Daylight/Standard shift JDK doesn't map these (doh)
String timezoneStrUC = timezoneStr.toUpperCase();
int daylightIndex = timezoneStrUC.indexOf("DAYLIGHT");
if (daylightIndex != -1) {
StringBuffer timezoneBuf = new StringBuffer();
timezoneBuf.append(timezoneStr.substring(0, daylightIndex));
timezoneBuf.append("Standard");
timezoneBuf.append(timezoneStr.substring(
daylightIndex + "DAYLIGHT".length(),
timezoneStr.length()));
timezoneStr = timezoneBuf.toString();
}
return (String)TIMEZONE_MAPPINGS.get(timezoneStr);
}
public static Timestamp changeTimezone(Timestamp tstamp, TimeZone fromTz,
TimeZone toTz)
{
/*
// Convert the timestamp to the GMT timezone
Calendar fromCal = Calendar.getInstance(fromTz);
fromCal.setTime(tstamp);
int fromOffset =
fromCal.get(Calendar.ZONE_OFFSET)
+ fromCal.get(Calendar.DST_OFFSET);
Calendar toCal = Calendar.getInstance(toTz);
toCal.setTime(tstamp);
int toOffset =
toCal.get(Calendar.ZONE_OFFSET) + toCal.get(Calendar.DST_OFFSET);
int offsetDiff = toOffset - fromOffset;
long toTime = toCal.getTime().getTime();
toTime += offsetDiff;
Timestamp changedTimestamp = new Timestamp(toTime);
return changedTimestamp;
*/
return tstamp;
}
public static Time changeTimezone(Time t, TimeZone fromTz, TimeZone toTz)
{
/*
// Convert the timestamp to the GMT timezone
Calendar fromCal = Calendar.getInstance(fromTz);
fromCal.setTime(t);
int fromOffset =
fromCal.get(Calendar.ZONE_OFFSET)
+ fromCal.get(Calendar.DST_OFFSET);
Calendar toCal = Calendar.getInstance(toTz);
toCal.setTime(t);
int toOffset =
toCal.get(Calendar.ZONE_OFFSET) + toCal.get(Calendar.DST_OFFSET);
int offsetDiff = toOffset - fromOffset;
long toTime = toCal.getTime().getTime();
toTime += offsetDiff;
Time changedTime = new Time(toTime);
return changedTime;
*/
return t;
}
}