{"id":12512,"date":"2022-07-27T12:55:54","date_gmt":"2022-07-27T03:55:54","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=12512"},"modified":"2022-07-27T12:56:34","modified_gmt":"2022-07-27T03:56:34","slug":"postgresql%ec%9d%98-time-zone-%eb%b3%80%ea%b2%bd","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=12512","title":{"rendered":"PostgreSQL\uc758 Time Zone \ubcc0\uacbd"},"content":{"rendered":"<p>\uba3c\uc800 \ud604\uc7ac DB\uc5d0 \ub300\ud55c TimeZone\uc744 \ud655\uc778\ud558\uae30 \uc704\ud55c \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n<p><code>SHOW timezone;<\/code><\/p>\n<p>\ud0c0\uc784\uc874\uc774 \ud55c\uad6d\uc774 \uc544\ub2d0 \uacbd\uc6b0 \uc544\ub798\uc758 \uba85\ub839\uc744 \ud1b5\ud574 \ud55c\uad6d\uc73c\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4. !DB_NAME!\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\uc774 \ub4e4\uc5b4\uac11\ub2c8\ub2e4.<\/p>\n<p><code>ALTER DATABASE !DB_NAME! SET timezone = 'Asia\/Seoul';<\/code><\/p>\n<p>\ud0c0\uc784\uc874\uc744 \ubcc0\uacbd\ud55c \ub4a4\uc5d0\ub294 PostgreSQL\uc744 \ubc18\ub4dc\uc2dc \uc7ac\uc2dc\uc791\ud574\uc57c\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uba3c\uc800 \ud604\uc7ac DB\uc5d0 \ub300\ud55c TimeZone\uc744 \ud655\uc778\ud558\uae30 \uc704\ud55c \uba85\ub839\uc5b4\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. SHOW timezone; \ud0c0\uc784\uc874\uc774 \ud55c\uad6d\uc774 \uc544\ub2d0 \uacbd\uc6b0 \uc544\ub798\uc758 \uba85\ub839\uc744 \ud1b5\ud574 \ud55c\uad6d\uc73c\ub85c \ubcc0\uacbd\ud569\ub2c8\ub2e4. !DB_NAME!\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\uc774 \ub4e4\uc5b4\uac11\ub2c8\ub2e4. ALTER DATABASE !DB_NAME! SET timezone = &#8216;Asia\/Seoul&#8217;; \ud0c0\uc784\uc874\uc744 \ubcc0\uacbd\ud55c \ub4a4\uc5d0\ub294 PostgreSQL\uc744 \ubc18\ub4dc\uc2dc \uc7ac\uc2dc\uc791\ud574\uc57c\ud569\ub2c8\ub2e4.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-12512","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/12512","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12512"}],"version-history":[{"count":4,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/12512\/revisions"}],"predecessor-version":[{"id":12515,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/12512\/revisions\/12515"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12512"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12512"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12512"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}