{"id":5645,"date":"2016-03-01T18:19:43","date_gmt":"2016-03-01T09:19:43","guid":{"rendered":"http:\/\/www.skyarch.net\/blog\/?p=5645"},"modified":"2016-03-11T09:47:33","modified_gmt":"2016-03-11T00:47:33","slug":"mysql-time_zone%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6","status":"publish","type":"post","link":"https:\/\/www.skyarch.net\/blog\/mysql-time_zone%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6\/","title":{"rendered":"MySQL time_zone\u306b\u3064\u3044\u3066"},"content":{"rendered":"<p>\u540c\u50da\u304c\u3001time_zone\u306e\u8a2d\u5b9a\u306b\u82e6\u6226\u3057\u3066\u3044\u305f\u306e\u3067\u3002\u3002\u3002<br \/>\n\u25c6\u3000time_zone\u306e\u78ba\u8a8d\u30fb\u8a2d\u5b9a\u306f\u4e0b\u8a18\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u3010\u30bf\u30a4\u30e0 \u30be\u30fc\u30f3\u306e\u78ba\u8a8d\u3011<br \/>\nSELECT @@global.time_zone, @@session.time_zone;<\/p>\n<p>SHOW TABLES LIKE '%time_zone%';<\/p>\n<p>\u203btime_zone \u306e\u521d\u671f\u5024\u306f\u3001'SYSTEM' \u3067\u3001\u30b5\u30fc\u30d0\u3068\u30b7\u30b9\u30c6\u30e0\u306e<br \/>\n\u30bf\u30a4\u30e0 \u30be\u30fc\u30f3\u304c\u540c\u3058\u3067\u3042\u308b\u3053\u3068\u3092\u793a\u3057\u307e\u3059\u3002<\/p>\n<p>\u3010my.cnf\u3011<br \/>\ndefault-time-zone='timezone'<\/p>\n<p>\u203bmy.cnf\u3067\u53cd\u6620\u3055\u305b\u308b\u5834\u5408\u306f\u3001MySQL\u3092\u518d\u8d77\u52d5\u3057\u3066\u4e0b\u3055\u3044\u3002<\/p>\n<p>\u3010\u30af\u30a8\u30ea\u3011<\/p>\n<p>SET GLOBAL time_zone = timezone;<\/p>\n<p>&nbsp;<\/p>\n<p>\u25c6\u3000time_zone\u306e\u5909\u66f4\u3092\u3057\u3088\u3046\u3068\u3057\u3066\u3001\u30a8\u30e9\u30fc\u306b\u306a\u308b\u5834\u5408\u3001<br \/>\n\u30bf\u30a4\u30e0 \u30be\u30fc\u30f3\u306e\u60c5\u5831\u304c\u30ed\u30fc\u30c9\u3055\u308c\u3066\u3044\u306a\u3044\u53ef\u80fd\u6027\u304c\u3042\u308a\u307e\u3059\u306e\u3067\u3001<br \/>\n\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3067\u5b9f\u884c\u3057\u305f\u4e0a\u3067\u3001\u518d\u5ea6\u3001time_zone\u306e\u5909\u66f4\u3092\u3057\u3066\u307f\u3066\u4e0b\u3055\u3044\u3002<\/p>\n<p>\u4f8b\uff09\u300cAsia\/Tokyo\u300d\u306e\u5834\u5408<br \/>\nmysql_tzinfo_to_sql \/usr\/share\/zoneinfo\/Asia\/Tokyo Asia\/Tokyo | mysql -u root -p mysql<\/p>\n<p>&nbsp;<\/p>\n<p>\u25c6\u3000\u30bb\u30c3\u30b7\u30e7\u30f3\u6bce\u306b\u30bf\u30a4\u30e0\u30be\u30fc\u30f3\u3092\u8a2d\u5b9a\u3057\u305f\u3044\u5834\u5408\u306b\u3064\u3044\u3066\u3082\u8a18\u8f09\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<p>\u203bAWS\u306eRDS\u3068\u304b\u3067\u3059\u304b\u306d<\/p>\n<p>my.cnf\u306b\u3000\u201cinit_connect\u201d \u30d1\u30e9\u30e1\u30fc\u30bf\u3092\u8a2d\u5b9a\u3057\u307e\u3059\u3002<br \/>\n\u4e0b\u8a18\u306e\u4f8b\u306f\u3001rds\u3067\u59cb\u307e\u308b\u30e6\u30fc\u30b6\u30fc\u540d\u306e\u5834\u5408\u306f\u300cUTC\u300d\u3001\u305d\u308c\u4ee5\u5916\u306e\u30e6\u30fc\u30b6\u30fc\u306f\u300cAsia\/Tokyo\u300d\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<p>\u4f8b1\uff09<br \/>\ninit_connect=\"SET SESSION time_zone = IF(POSITION('rds' IN CURRENT_USER()) = 1,'UTC','Asia\/Tokyo')\"<\/p>\n<p>\u4f8b2\uff09<br \/>\ninit_connect=\"SET SESSION time_zone = CASE WHEN POSITION('rds' IN CURRENT_USER()) = 1 THEN 'UTC' ELSE 'Asia\/Tokyo' END;\"<\/p>\n<p>###\u00a0init_connect\u30d1\u30e9\u30e1\u30fc\u30bf\u306e\u6ce8\u610f\u4e8b\u9805 ###<br \/>\ninit_connect\u30d1\u30e9\u30e1\u30fc\u30bf\u3067\u6307\u5b9a\u3057\u305f\u3082\u306e\u306f\u3001SUPER\u6a29\u9650\u3092\u3082\u3064\u30e6\u30fc\u30b6\u30fc\u306b\u5bfe\u3057\u3066\u306f\u5b9f\u884c\u3055\u308c\u307e\u305b\u3093\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u540c\u50da\u304c\u3001time_zone\u306e\u8a2d\u5b9a\u306b\u82e6\u6226\u3057\u3066\u3044\u305f\u306e\u3067\u3002\u3002\u3002 \u25c6\u3000time_zone\u306e\u78ba\u8a8d\u30fb\u8a2d\u5b9a\u306f\u4e0b\u8a18\u306b\u306a\u308a\u307e\u3059\u3002 \u3010\u30bf\u30a4\u30e0 \u30be\u30fc\u30f3\u306e\u78ba\u8a8d\u3011 SELECT @@global.time_zone, @@session.time&#8230;<\/p>\n","protected":false},"author":1,"featured_media":2394,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_locale":"ja","_original_post":"5645","footnotes":""},"categories":[24],"tags":[],"class_list":{"0":"post-5645","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-mysql","8":"ja"},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/5645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/comments?post=5645"}],"version-history":[{"count":6,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/5645\/revisions"}],"predecessor-version":[{"id":5718,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/posts\/5645\/revisions\/5718"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media\/2394"}],"wp:attachment":[{"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/media?parent=5645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/categories?post=5645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.skyarch.net\/blog\/wp-json\/wp\/v2\/tags?post=5645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}