{"id":2347,"date":"2016-04-01T23:27:50","date_gmt":"2016-04-01T23:27:50","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=2347"},"modified":"2017-01-26T22:07:38","modified_gmt":"2017-01-26T13:07:38","slug":"postgresql%ec%9d%98-timestamp-%ed%95%84%eb%93%9c%ec%97%90-%ea%b0%92-insert","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=2347","title":{"rendered":"PostgreSQL\uc758 timestamp \ud544\ub4dc\uc5d0 \uac12 INSERT"},"content":{"rendered":"<p><P>PostgreSQL\uc5d0\uc11c \ub144\/\uc6d4\/\uc77c\uacfc \uc2dc\uac04\uc744 \ubaa8\ub450 \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \ud544\ub4dc \ud0c0\uc785\uc778 timestamp\uc5d0 \uac12\uc744 \ub123\ub294 Java \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/P><\/p>\n<pre>\r\nCalendar cal = Calendar.getInstance();\r\nTimestamp timestamp = new Timestamp(cal.getTimeInMillis());\r\n<\/pre>\n<p><P>\ucf54\ub4dc\ub97c \ud638\ucd9c\ud558\ub294 \uc2dc\uc810\uc5d0\uc11c\uc758 \uc2dc\uac04 \uac12\uc744 \uc5bb\uc5b4 \uc624\ub294 \ucf54\ub4dc\uc774\uace0, \uc774\ub97c INSERT \ubb38\uc73c\ub85c \ucd94\uac00\ud560\ub54c\ub294 \ubb38\uc790\uc5f4 \ud615\ud0dc\ub85c \ub123\uc5b4 \uc8fc\uba74 \ub429\ub2c8\ub2e4. \uc989, \uc544\ub798\ucc98\ub7fc \ub9d0\uc785\ub2c8\ub2e4.<\/P><\/p>\n<pre>\r\nCalendar cal = Calendar.getInstance();  \r\nTimestamp timestamp = new Timestamp(cal.getTimeInMillis());\r\n\r\nStringBuilder sb = new StringBuilder();\r\n\r\nsb.append(\"INSERT INTO log (call_time)\");\r\nsb.append(\"VALUES (\");\r\nsb.append(\"'\");\r\nsb.append(timestamp);\r\nsb.append(\"')\");\r\n<\/pre>\n<p><P>log\ub77c\ub294 \ud14c\uc774\ube14\uc5d0 timestamp \ud544\ub4dc \ud0c0\uc785\uc758 call_time \ud544\ub4dc\uc5d0 \uac12\uc744 \uc800\uc7a5\ud558\ub294 \ucf54\ub4dc\uc785\ub2c8\ub2e4.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL\uc5d0\uc11c \ub144\/\uc6d4\/\uc77c\uacfc \uc2dc\uac04\uc744 \ubaa8\ub450 \uc800\uc7a5\ud560 \uc218 \uc788\ub294 \ud544\ub4dc \ud0c0\uc785\uc778 timestamp\uc5d0 \uac12\uc744 \ub123\ub294 Java \ucf54\ub4dc\uc785\ub2c8\ub2e4. Calendar cal = Calendar.getInstance(); Timestamp timestamp = new Timestamp(cal.getTimeInMillis()); \ucf54\ub4dc\ub97c \ud638\ucd9c\ud558\ub294 \uc2dc\uc810\uc5d0\uc11c\uc758 \uc2dc\uac04 \uac12\uc744 \uc5bb\uc5b4 \uc624\ub294 \ucf54\ub4dc\uc774\uace0, \uc774\ub97c INSERT \ubb38\uc73c\ub85c \ucd94\uac00\ud560\ub54c\ub294 \ubb38\uc790\uc5f4 \ud615\ud0dc\ub85c \ub123\uc5b4 \uc8fc\uba74 \ub429\ub2c8\ub2e4. \uc989, \uc544\ub798\ucc98\ub7fc \ub9d0\uc785\ub2c8\ub2e4. Calendar cal = Calendar.getInstance(); Timestamp timestamp = new Timestamp(cal.getTimeInMillis()); StringBuilder sb = &hellip; <\/p>\n<p class=\"link-more\"><a href=\"http:\/\/www.gisdeveloper.co.kr\/?p=2347\" class=\"more-link\">\ub354 \ubcf4\uae30<span class=\"screen-reader-text\"> &#8220;PostgreSQL\uc758 timestamp \ud544\ub4dc\uc5d0 \uac12 INSERT&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2347","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2347","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=2347"}],"version-history":[{"count":1,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2347\/revisions"}],"predecessor-version":[{"id":2684,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2347\/revisions\/2684"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2347"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2347"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2347"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}