mysql-connector-java 6.x 时区设置

标签：mysql-connector-java 6.x 时区设置

       最近遇到了一个问题，java从mysql从读出的时间与本地时间有14个小时的时间差，经查证、测试解决了此问题，在此总结一下：

一、使用mysql-connector-java 6.x版本驱动需要做如下配置：

1、引入pom

<dependency>  <groupId>mysql</groupId>  <artifactId>mysql-connector-java</artifactId>  <version>6.0.6</version></dependency>

2、设置jdbc连接、驱动

jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&serverTimezone=UTC&characterEncoding=utf-8&allowMultiQueries=truecom.mysql.cj.jdbc.Driver

二、设置mysql数据时区

1、查看mysql时区

show variables like "%time_zone%"

2、修改mysql时区

（1）方法一

set global time_zone = ‘+8:00‘; ##修改mysql全局时区为北京时间，即我们所在的东8区set time_zone = ‘+8:00‘; ##修改当前会话时区flush privileges; #立即生效

（2）方法二、通过修改my.cnf配置文件来修改时区

# vim /etc/my.cnf ##在[mysqld]区域中加上default-time_zone = ‘+8:00‘# /etc/init.d/mysqld restart ##重启mysql使新时区生效

三、分析时区设置问题

       通过上面的设置，我们把mysql数据库的时区设置成了中国的时区‘utc+8’，而serverTimezone=UTC设置的是utc时区，两者不同，所以会发现从数据库读出的时间与本地时间差几个小时。要解决这个问题，需要让serverTimezone的设置与数据库的时区保持一致。我们可以选择修改serverTimezone的设置为serverTimezone=Asia/Shanghai，或者修改数据库的时区为‘+0:00’。

四、serverTimezone支持的值说明

1、utc时区：serverTimezone=UTC

2、中国时区：serverTimezone=GMT%2B8（GMT+8这种方式支持全部时区，通过修改最后的数字实现，不过%2B不能写成+）

3、查看官方源码，可以看到serverTimezone支持的相关设置如下，如：中国的时区可设置为：serverTimezone=Asia/Shanghai

#Windows Zones#Mon Sep 28 16:41:59 WEST 2015AUS\ Central\ Daylight\ Time=Australia/DarwinAUS\ Central\ Standard\ Time=Australia/DarwinAUS\ Eastern\ Daylight\ Time=Australia/SydneyAUS\ Eastern\ Standard\ Time=Australia/SydneyAfghanistan\ Daylight\ Time=Asia/KabulAfghanistan\ Standard\ Time=Asia/KabulAlaskan\ Daylight\ Time=America/AnchorageAlaskan\ Standard\ Time=America/AnchorageArab\ Daylight\ Time=Asia/RiyadhArab\ Standard\ Time=Asia/RiyadhArabian\ Daylight\ Time=Asia/DubaiArabian\ Standard\ Time=Asia/DubaiArabic\ Daylight\ Time=Asia/BaghdadArabic\ Standard\ Time=Asia/BaghdadArgentina\ Daylight\ Time=America/Buenos_AiresArgentina\ Standard\ Time=America/Buenos_AiresAtlantic\ Daylight\ Time=America/HalifaxAtlantic\ Standard\ Time=America/HalifaxAzerbaijan\ Daylight\ Time=Asia/BakuAzerbaijan\ Standard\ Time=Asia/BakuAzores\ Daylight\ Time=Atlantic/AzoresAzores\ Standard\ Time=Atlantic/AzoresBahia\ Daylight\ Time=America/BahiaBahia\ Standard\ Time=America/BahiaBangladesh\ Daylight\ Time=Asia/DhakaBangladesh\ Standard\ Time=Asia/DhakaBelarus\ Daylight\ Time=Europe/MinskBelarus\ Standard\ Time=Europe/MinskCanada\ Central\ Daylight\ Time=America/ReginaCanada\ Central\ Standard\ Time=America/ReginaCape\ Verde\ Daylight\ Time=Atlantic/Cape_VerdeCape\ Verde\ Standard\ Time=Atlantic/Cape_VerdeCaucasus\ Daylight\ Time=Asia/YerevanCaucasus\ Standard\ Time=Asia/YerevanCen.\ Australia\ Daylight\ Time=Australia/AdelaideCen.\ Australia\ Standard\ Time=Australia/AdelaideCentral\ America\ Daylight\ Time=America/GuatemalaCentral\ America\ Standard\ Time=America/GuatemalaCentral\ Asia\ Daylight\ Time=Asia/AlmatyCentral\ Asia\ Standard\ Time=Asia/AlmatyCentral\ Brazilian\ Daylight\ Time=America/CuiabaCentral\ Brazilian\ Standard\ Time=America/CuiabaCentral\ Daylight\ Time=America/ChicagoCentral\ Daylight\ Time\ (Mexico)=America/Mexico_CityCentral\ Europe\ Daylight\ Time=Europe/BudapestCentral\ Europe\ Standard\ Time=Europe/BudapestCentral\ European\ Daylight\ Time=Europe/WarsawCentral\ European\ Standard\ Time=Europe/WarsawCentral\ Pacific\ Daylight\ Time=Pacific/GuadalcanalCentral\ Pacific\ Standard\ Time=Pacific/GuadalcanalCentral\ Standard\ Time=America/ChicagoCentral\ Standard\ Time\ (Mexico)=America/Mexico_CityChina\ Daylight\ Time=Asia/ShanghaiChina\ Standard\ Time=Asia/ShanghaiDateline\ Daylight\ Time=Etc/GMT+12Dateline\ Standard\ Time=Etc/GMT+12E.\ Africa\ Daylight\ Time=Africa/NairobiE.\ Africa\ Standard\ Time=Africa/NairobiE.\ Australia\ Daylight\ Time=Australia/BrisbaneE.\ Australia\ Standard\ Time=Australia/BrisbaneE.\ South\ America\ Daylight\ Time=America/Sao_PauloE.\ South\ America\ Standard\ Time=America/Sao_PauloEastern\ Daylight\ Time=America/New_YorkEastern\ Daylight\ Time\ (Mexico)=America/CancunEastern\ Standard\ Time=America/New_YorkEastern\ Standard\ Time\ (Mexico)=America/CancunEgypt\ Daylight\ Time=Africa/CairoEgypt\ Standard\ Time=Africa/CairoEkaterinburg\ Daylight\ Time=Asia/YekaterinburgEkaterinburg\ Standard\ Time=Asia/YekaterinburgFLE\ Daylight\ Time=Europe/KievFLE\ Standard\ Time=Europe/KievFiji\ Daylight\ Time=Pacific/FijiFiji\ Standard\ Time=Pacific/FijiGMT\ Daylight\ Time=Europe/LondonGMT\ Standard\ Time=Europe/LondonGTB\ Daylight\ Time=Europe/BucharestGTB\ Standard\ Time=Europe/BucharestGeorgian\ Daylight\ Time=Asia/TbilisiGeorgian\ Standard\ Time=Asia/TbilisiGreenland\ Daylight\ Time=America/GodthabGreenland\ Standard\ Time=America/GodthabGreenwich\ Daylight\ Time=Atlantic/ReykjavikGreenwich\ Standard\ Time=Atlantic/ReykjavikHawaiian\ Daylight\ Time=Pacific/HonoluluHawaiian\ Standard\ Time=Pacific/HonoluluIndia\ Daylight\ Time=Asia/CalcuttaIndia\ Standard\ Time=Asia/CalcuttaIran\ Daylight\ Time=Asia/TehranIran\ Standard\ Time=Asia/TehranIsrael\ Daylight\ Time=Asia/JerusalemIsrael\ Standard\ Time=Asia/JerusalemJordan\ Daylight\ Time=Asia/AmmanJordan\ Standard\ Time=Asia/AmmanKaliningrad\ Daylight\ Time=Europe/KaliningradKaliningrad\ Standard\ Time=Europe/KaliningradKorea\ Daylight\ Time=Asia/SeoulKorea\ Standard\ Time=Asia/SeoulLibya\ Daylight\ Time=Africa/TripoliLibya\ Standard\ Time=Africa/TripoliLine\ Islands\ Daylight\ Time=Pacific/KiritimatiLine\ Islands\ Standard\ Time=Pacific/KiritimatiMagadan\ Daylight\ Time=Asia/MagadanMagadan\ Standard\ Time=Asia/MagadanMauritius\ Daylight\ Time=Indian/MauritiusMauritius\ Standard\ Time=Indian/MauritiusMiddle\ East\ Daylight\ Time=Asia/BeirutMiddle\ East\ Standard\ Time=Asia/BeirutMontevideo\ Daylight\ Time=America/MontevideoMontevideo\ Standard\ Time=America/MontevideoMorocco\ Daylight\ Time=Africa/CasablancaMorocco\ Standard\ Time=Africa/CasablancaMountain\ Daylight\ Time=America/DenverMountain\ Daylight\ Time\ (Mexico)=America/ChihuahuaMountain\ Standard\ Time=America/DenverMountain\ Standard\ Time\ (Mexico)=America/ChihuahuaMyanmar\ Daylight\ Time=Asia/RangoonMyanmar\ Standard\ Time=Asia/RangoonN.\ Central\ Asia\ Daylight\ Time=Asia/NovosibirskN.\ Central\ Asia\ Standard\ Time=Asia/NovosibirskNamibia\ Daylight\ Time=Africa/WindhoekNamibia\ Standard\ Time=Africa/WindhoekNepal\ Daylight\ Time=Asia/KatmanduNepal\ Standard\ Time=Asia/KatmanduNew\ Zealand\ Daylight\ Time=Pacific/AucklandNew\ Zealand\ Standard\ Time=Pacific/AucklandNewfoundland\ Daylight\ Time=America/St_JohnsNewfoundland\ Standard\ Time=America/St_JohnsNorth\ Asia\ Daylight\ Time=Asia/KrasnoyarskNorth\ Asia\ East\ Daylight\ Time=Asia/IrkutskNorth\ Asia\ East\ Standard\ Time=Asia/IrkutskNorth\ Asia\ Standard\ Time=Asia/KrasnoyarskPacific\ Daylight\ Time=America/Los_AngelesPacific\ Daylight\ Time\ (Mexico)=America/Santa_IsabelPacific\ SA\ Daylight\ Time=America/SantiagoPacific\ SA\ Standard\ Time=America/SantiagoPacific\ Standard\ Time=America/Los_AngelesPacific\ Standard\ Time\ (Mexico)=America/Santa_IsabelPakistan\ Daylight\ Time=Asia/KarachiPakistan\ Standard\ Time=Asia/KarachiParaguay\ Daylight\ Time=America/AsuncionParaguay\ Standard\ Time=America/AsuncionRomance\ Daylight\ Time=Europe/ParisRomance\ Standard\ Time=Europe/ParisRussia\ Time\ Zone\ 10=Asia/SrednekolymskRussia\ Time\ Zone\ 11=Asia/KamchatkaRussia\ Time\ Zone\ 3=Europe/SamaraRussian\ Daylight\ Time=Europe/MoscowRussian\ Standard\ Time=Europe/MoscowSA\ Eastern\ Daylight\ Time=America/CayenneSA\ Eastern\ Standard\ Time=America/CayenneSA\ Pacific\ Daylight\ Time=America/BogotaSA\ Pacific\ Standard\ Time=America/BogotaSA\ Western\ Daylight\ Time=America/La_PazSA\ Western\ Standard\ Time=America/La_PazSE\ Asia\ Daylight\ Time=Asia/BangkokSE\ Asia\ Standard\ Time=Asia/BangkokSamoa\ Daylight\ Time=Pacific/ApiaSamoa\ Standard\ Time=Pacific/ApiaSingapore\ Daylight\ Time=Asia/SingaporeSingapore\ Standard\ Time=Asia/SingaporeSouth\ Africa\ Daylight\ Time=Africa/JohannesburgSouth\ Africa\ Standard\ Time=Africa/JohannesburgSri\ Lanka\ Daylight\ Time=Asia/ColomboSri\ Lanka\ Standard\ Time=Asia/ColomboSyria\ Daylight\ Time=Asia/DamascusSyria\ Standard\ Time=Asia/DamascusTaipei\ Daylight\ Time=Asia/TaipeiTaipei\ Standard\ Time=Asia/TaipeiTasmania\ Daylight\ Time=Australia/HobartTasmania\ Standard\ Time=Australia/HobartTokyo\ Daylight\ Time=Asia/TokyoTokyo\ Standard\ Time=Asia/TokyoTonga\ Daylight\ Time=Pacific/TongatapuTonga\ Standard\ Time=Pacific/TongatapuTurkey\ Daylight\ Time=Europe/IstanbulTurkey\ Standard\ Time=Europe/IstanbulUS\ Eastern\ Daylight\ Time=America/IndianapolisUS\ Eastern\ Standard\ Time=America/IndianapolisUS\ Mountain\ Daylight\ Time=America/PhoenixUS\ Mountain\ Standard\ Time=America/PhoenixUTC=Etc/GMTUTC+12=Etc/GMT-12UTC-02=Etc/GMT+2UTC-11=Etc/GMT+11Ulaanbaatar\ Daylight\ Time=Asia/UlaanbaatarUlaanbaatar\ Standard\ Time=Asia/UlaanbaatarVenezuela\ Daylight\ Time=America/CaracasVenezuela\ Standard\ Time=America/CaracasVladivostok\ Daylight\ Time=Asia/VladivostokVladivostok\ Standard\ Time=Asia/VladivostokW.\ Australia\ Daylight\ Time=Australia/PerthW.\ Australia\ Standard\ Time=Australia/PerthW.\ Central\ Africa\ Daylight\ Time=Africa/LagosW.\ Central\ Africa\ Standard\ Time=Africa/LagosW.\ Europe\ Daylight\ Time=Europe/BerlinW.\ Europe\ Standard\ Time=Europe/BerlinWest\ Asia\ Daylight\ Time=Asia/TashkentWest\ Asia\ Standard\ Time=Asia/TashkentWest\ Pacific\ Daylight\ Time=Pacific/Port_MoresbyWest\ Pacific\ Standard\ Time=Pacific/Port_MoresbyYakutsk\ Daylight\ Time=Asia/YakutskYakutsk\ Standard\ Time=Asia/Yakutsk#Linked Time Zones alias#Mon Sep 28 16:41:59 WEST 2015Africa/Addis_Ababa=Africa/NairobiAfrica/Asmara=Africa/NairobiAfrica/Asmera=Africa/NairobiAfrica/Bamako=Africa/AbidjanAfrica/Bangui=Africa/LagosAfrica/Banjul=Africa/AbidjanAfrica/Blantyre=Africa/MaputoAfrica/Brazzaville=Africa/LagosAfrica/Bujumbura=Africa/MaputoAfrica/Conakry=Africa/AbidjanAfrica/Dakar=Africa/AbidjanAfrica/Dar_es_Salaam=Africa/NairobiAfrica/Djibouti=Africa/NairobiAfrica/Douala=Africa/LagosAfrica/Freetown=Africa/AbidjanAfrica/Gaborone=Africa/MaputoAfrica/Harare=Africa/MaputoAfrica/Juba=Africa/KhartoumAfrica/Kampala=Africa/NairobiAfrica/Kigali=Africa/MaputoAfrica/Kinshasa=Africa/LagosAfrica/Libreville=Africa/LagosAfrica/Lome=Africa/AbidjanAfrica/Luanda=Africa/LagosAfrica/Lubumbashi=Africa/MaputoAfrica/Lusaka=Africa/MaputoAfrica/Malabo=Africa/LagosAfrica/Maseru=Africa/JohannesburgAfrica/Mbabane=Africa/JohannesburgAfrica/Mogadishu=Africa/NairobiAfrica/Niamey=Africa/LagosAfrica/Nouakchott=Africa/AbidjanAfrica/Ouagadougou=Africa/AbidjanAfrica/Porto-Novo=Africa/LagosAfrica/Sao_Tome=Africa/AbidjanAfrica/Timbuktu=Africa/AbidjanAmerica/Anguilla=America/Port_of_SpainAmerica/Antigua=America/Port_of_SpainAmerica/Argentina/ComodRivadavia=America/Argentina/CatamarcaAmerica/Aruba=America/CuracaoAmerica/Atka=America/AdakAmerica/Buenos_Aires=America/Argentina/Buenos_AiresAmerica/Catamarca=America/Argentina/CatamarcaAmerica/Coral_Harbour=America/AtikokanAmerica/Cordoba=America/Argentina/CordobaAmerica/Dominica=America/Port_of_SpainAmerica/Ensenada=America/TijuanaAmerica/Fort_Wayne=America/Indiana/IndianapolisAmerica/Grenada=America/Port_of_SpainAmerica/Guadeloupe=America/Port_of_SpainAmerica/Indianapolis=America/Indiana/IndianapolisAmerica/Jujuy=America/Argentina/JujuyAmerica/Knox_IN=America/Indiana/KnoxAmerica/Kralendijk=America/CuracaoAmerica/Louisville=America/Kentucky/LouisvilleAmerica/Lower_Princes=America/CuracaoAmerica/Marigot=America/Port_of_SpainAmerica/Mendoza=America/Argentina/MendozaAmerica/Montreal=America/TorontoAmerica/Montserrat=America/Port_of_SpainAmerica/Porto_Acre=America/Rio_BrancoAmerica/Rosario=America/Argentina/CordobaAmerica/Shiprock=America/DenverAmerica/St_Barthelemy=America/Port_of_SpainAmerica/St_Kitts=America/Port_of_SpainAmerica/St_Lucia=America/Port_of_SpainAmerica/St_Thomas=America/Port_of_SpainAmerica/St_Vincent=America/Port_of_SpainAmerica/Tortola=America/Port_of_SpainAmerica/Virgin=America/Port_of_SpainAntarctica/McMurdo=Pacific/AucklandAntarctica/South_Pole=Pacific/AucklandArctic/Longyearbyen=Europe/OsloAsia/Aden=Asia/RiyadhAsia/Ashkhabad=Asia/AshgabatAsia/Bahrain=Asia/QatarAsia/Calcutta=Asia/KolkataAsia/Chongqing=Asia/ShanghaiAsia/Chungking=Asia/ShanghaiAsia/Dacca=Asia/DhakaAsia/Harbin=Asia/ShanghaiAsia/Istanbul=Europe/IstanbulAsia/Kashgar=Asia/UrumqiAsia/Katmandu=Asia/KathmanduAsia/Kuwait=Asia/RiyadhAsia/Macao=Asia/MacauAsia/Muscat=Asia/DubaiAsia/Phnom_Penh=Asia/BangkokAsia/Saigon=Asia/Ho_Chi_MinhAsia/Tel_Aviv=Asia/JerusalemAsia/Thimbu=Asia/ThimphuAsia/Ujung_Pandang=Asia/MakassarAsia/Ulan_Bator=Asia/UlaanbaatarAsia/Vientiane=Asia/BangkokAtlantic/Faeroe=Atlantic/FaroeAtlantic/Jan_Mayen=Europe/OsloAtlantic/St_Helena=Africa/AbidjanAustralia/ACT=Australia/SydneyAustralia/Canberra=Australia/SydneyAustralia/LHI=Australia/Lord_HoweAustralia/NSW=Australia/SydneyAustralia/North=Australia/DarwinAustralia/Queensland=Australia/BrisbaneAustralia/South=Australia/AdelaideAustralia/Tasmania=Australia/HobartAustralia/Victoria=Australia/MelbourneAustralia/West=Australia/PerthAustralia/Yancowinna=Australia/Broken_HillBrazil/Acre=America/Rio_BrancoBrazil/DeNoronha=America/NoronhaBrazil/East=America/Sao_PauloBrazil/West=America/ManausCanada/Atlantic=America/HalifaxCanada/Central=America/WinnipegCanada/East-Saskatchewan=America/ReginaCanada/Eastern=America/TorontoCanada/Mountain=America/EdmontonCanada/Newfoundland=America/St_JohnsCanada/Pacific=America/VancouverCanada/Saskatchewan=America/ReginaCanada/Yukon=America/WhitehorseChile/Continental=America/SantiagoChile/EasterIsland=Pacific/EasterCuba=America/HavanaEgypt=Africa/CairoEire=Europe/DublinEurope/Belfast=Europe/LondonEurope/Bratislava=Europe/PragueEurope/Busingen=Europe/ZurichEurope/Guernsey=Europe/LondonEurope/Isle_of_Man=Europe/LondonEurope/Jersey=Europe/LondonEurope/Ljubljana=Europe/BelgradeEurope/Mariehamn=Europe/HelsinkiEurope/Nicosia=Asia/NicosiaEurope/Podgorica=Europe/BelgradeEurope/San_Marino=Europe/RomeEurope/Sarajevo=Europe/BelgradeEurope/Skopje=Europe/BelgradeEurope/Tiraspol=Europe/ChisinauEurope/Vaduz=Europe/ZurichEurope/Vatican=Europe/RomeEurope/Zagreb=Europe/BelgradeGB=Europe/LondonGB-Eire=Europe/LondonGMT+0=Etc/GMTGMT-0=Etc/GMTGMT0=Etc/GMTGreenwich=Etc/GMTHongkong=Asia/Hong_KongIceland=Atlantic/ReykjavikIndian/Antananarivo=Africa/NairobiIndian/Comoro=Africa/NairobiIndian/Mayotte=Africa/NairobiIran=Asia/TehranIsrael=Asia/JerusalemJamaica=America/JamaicaJapan=Asia/TokyoKwajalein=Pacific/KwajaleinLibya=Africa/TripoliMexico/BajaNorte=America/TijuanaMexico/BajaSur=America/MazatlanMexico/General=America/Mexico_CityNZ=Pacific/AucklandNZ-CHAT=Pacific/ChathamNavajo=America/DenverPRC=Asia/ShanghaiPacific/Johnston=Pacific/HonoluluPacific/Midway=Pacific/Pago_PagoPacific/Ponape=Pacific/PohnpeiPacific/Saipan=Pacific/GuamPacific/Samoa=Pacific/Pago_PagoPacific/Truk=Pacific/ChuukPacific/Yap=Pacific/ChuukPoland=Europe/WarsawPortugal=Europe/LisbonROC=Asia/TaipeiROK=Asia/SeoulSingapore=Asia/SingaporeTurkey=Europe/IstanbulUCT=Etc/UCTUS/Alaska=America/AnchorageUS/Aleutian=America/AdakUS/Arizona=America/PhoenixUS/Central=America/ChicagoUS/East-Indiana=America/Indiana/IndianapolisUS/Eastern=America/New_YorkUS/Hawaii=Pacific/HonoluluUS/Indiana-Starke=America/Indiana/KnoxUS/Michigan=America/DetroitUS/Mountain=America/DenverUS/Pacific=America/Los_AngelesUS/Pacific-New=America/Los_AngelesUS/Samoa=Pacific/Pago_PagoUniversal=Etc/UTCW-SU=Europe/MoscowZulu=Etc/UTC#Standard (IANA) abbreviations#Mon Sep 28 16:41:59 WEST 2015ACWST=Australia/EuclaAFT=Asia/KabulALMT=Asia/AlmatyANAT=Asia/AnadyrAZOST=Atlantic/AzoresAZOT=Atlantic/AzoresAZST=Asia/BakuAZT=Asia/BakuBDT=Asia/DhakaBNT=Asia/BruneiBOT=America/La_PazBRST=America/Sao_PauloBTT=Asia/ThimphuCAT=Africa/MaputoCCT=Indian/CocosCHADT=Pacific/ChathamCHAST=Pacific/ChathamCHOST=Asia/ChoibalsanCHOT=Asia/ChoibalsanCHUT=Pacific/ChuukCKT=Pacific/RarotongaCOT=America/BogotaCVT=Atlantic/Cape_VerdeCXT=Indian/ChristmasChST=Pacific/GuamDAVT=Antarctica/DavisDDUT=Antarctica/DumontDUrvilleEAST=Pacific/EasterECT=America/GuayaquilEGST=America/ScoresbysundEGT=America/ScoresbysundFJST=Pacific/FijiFJT=Pacific/FijiFKST=Atlantic/StanleyFNT=America/NoronhaGALT=Pacific/GalapagosGAMT=Pacific/GambierGET=Asia/TbilisiGFT=America/CayenneGILT=Pacific/TarawaGYT=America/GuyanaHDT=America/AdakHKT=Asia/Hong_KongHOVST=Asia/HovdHOVT=Asia/HovdIDT=Asia/JerusalemIOT=Indian/ChagosIRST=Asia/TehranJST=Asia/TokyoKGT=Asia/BishkekKOST=Pacific/KosraeLHDT=Australia/Lord_HoweLHST=Australia/Lord_HoweLINT=Pacific/KiritimatiMAGT=Asia/MagadanMART=Pacific/MarquesasMAWT=Antarctica/MawsonMEST=METMET=METMIST=Antarctica/MacquarieMMT=Asia/RangoonMUT=Indian/MauritiusMVT=Indian/MaldivesNCT=Pacific/NoumeaNDT=America/St_JohnsNFT=Pacific/NorfolkNOVT=Asia/NovosibirskNPT=Asia/KathmanduNRT=Pacific/NauruNST=America/St_JohnsNUT=Pacific/NiueNZDT=Pacific/AucklandNZST=Pacific/AucklandOMST=Asia/OmskORAT=Asia/OralPET=America/LimaPETT=Asia/KamchatkaPGT=Pacific/Port_MoresbyPHOT=Pacific/EnderburyPHT=Asia/ManilaPKT=Asia/KarachiPMDT=America/MiquelonPMST=America/MiquelonPONT=Pacific/PohnpeiPWT=Pacific/PalauPYST=America/AsuncionPYT=America/AsuncionQYZT=Asia/QyzylordaRET=Indian/ReunionROTT=Antarctica/RotheraSAKT=Asia/SakhalinSAMT=Europe/SamaraSAST=Africa/JohannesburgSBT=Pacific/GuadalcanalSCT=Indian/MaheSGT=Asia/SingaporeSRET=Asia/SrednekolymskSRT=America/ParamariboSST=Pacific/Pago_PagoSYOT=Antarctica/SyowaTAHT=Pacific/TahitiTFT=Indian/KerguelenTJT=Asia/DushanbeTKT=Pacific/FakaofoTLT=Asia/DiliTMT=Asia/AshgabatTOT=Pacific/TongatapuTVT=Pacific/FunafutiULAST=Asia/UlaanbaatarULAT=Asia/UlaanbaatarUYT=America/MontevideoVET=America/CaracasVOST=Antarctica/VostokVUT=Pacific/EfateWAKT=Pacific/WakeWAST=Africa/WindhoekWFT=Pacific/WallisWGST=America/GodthabWGT=America/GodthabWIT=Asia/JayapuraWITA=Asia/MakassarWSDT=Pacific/ApiaWSST=Pacific/ApiaXJT=Asia/UrumqiYEKT=Asia/Yekaterinburg

以上内容在src\main\resources\com\mysql\cj\jdbc\util.TimeZoneMapping.properties，

= 后面的值为我们可以用来设置的值

本文出自 “星技传阅” 博客，请务必保留此出处http://snowtiger.blog.51cto.com/12931578/1967441

mysql-connector-java 6.x 时区设置

标签：mysql-connector-java 6.x 时区设置