{"id":4045,"date":"2017-09-22T21:36:20","date_gmt":"2017-09-23T04:36:20","guid":{"rendered":"https:\/\/www.couchbase.com\/blog\/?p=4045"},"modified":"2025-06-13T23:43:22","modified_gmt":"2025-06-14T06:43:22","slug":"dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1","status":"publish","type":"post","link":"https:\/\/www.couchbase.com\/blog\/ko\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/","title":{"rendered":"\uc624\ub77c\ud074 \ub0a0\uc9dc \ud615\uc2dd: N1QL \ubc0f \ub0a0\uc9dc-\uc2dc\uac04 \ud568\uc218 \uc9c0\uc6d0"},"content":{"rendered":"<p><span style=\"font-weight: 400\">\ub0a0\uc9dc \ubc0f \uc2dc\uac04 \ud568\uc218\uc640 \ud615\uc2dd\uc740 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9c8\ub2e4 \ub2e4\ub97c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc774 \uae00\uc5d0\uc11c\ub294 Couchbase ISO \uae30\ubc18 \ub0a0\uc9dc-\uc2dc\uac04 \ud568\uc218\uc640 Oracle \ub0a0\uc9dc \ud615\uc2dd\uc744 \ube44\uad50\ud558\uaca0\uc2b5\ub2c8\ub2e4. \ub0a0\uc9dc \ud615\uc2dd\uc740 NoSQL JSON \ud615\uc2dd\uc758 \ud2b9\uc131\uc73c\ub85c \uc778\ud574 \uad00\uacc4\ud615 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub9c8\ub2e4 \ub2e4\ub985\ub2c8\ub2e4. \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uae30 <a href=\"https:\/\/resources.couchbase.com\/c\/vid-gain-flexibility-of-nosql?x=S3S4iI\">\uc774 \uc6f9\uce90\uc2a4\ud2b8\uc5d0\uc11c<\/a> \ub97c \ud1b5\ud574 SQL \uc9c0\uc2dd\uc744 \ud76c\uc0dd\ud558\uc9c0 \uc54a\uc73c\uba74\uc11c\ub3c4 <a href=\"https:\/\/resources.couchbase.com\/c\/vid-gain-flexibility-of-nosql?x=S3S4iI\">NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ucffc\ub9ac\uc758 \uc720\uc5f0\uc131 \uc720\uc9c0<\/a>.<\/span><\/p>\n<h2>\uc624\ub77c\ud074 \ub0a0\uc9dc\/\uc2dc\uac04 \uc720\ud615<\/h2>\n<p><span style=\"font-weight: 400\">\uc624\ub77c\ud074\uc5d0\uc11c\ub294 <em>\ub0a0\uc9dc<\/em> \ud615\uc2dd\uacfc <em>\uc2dc\uac04\ub300<\/em> \uae30\ub2a5\uc5d0\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc5ec\ub7ec \ub370\uc774\ud130 \uc720\ud615\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4: <em>\ub0a0\uc9dc<\/em>, <em>\ud0c0\uc784\uc2a4\ud0ec\ud504<\/em>, <em>\uc2dc\uac04\ub300\uac00 \ud3ec\ud568\ub41c \ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \uadf8\ub9ac\uace0 <em>\ud604\uc9c0 \uc2dc\uac04\ub300\uac00 \ud3ec\ud568\ub41c \ud0c0\uc784\uc2a4\ud0ec\ud504<\/em>. . <em>\ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \ub370\uc774\ud130 \uc720\ud615\uc740 <em>\ub0a0\uc9dc<\/em> \uc720\ud615\uc785\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">Oracle\uc758 \ub0a0\uc9dc \ud615\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \ud45c\ud604\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong>\ub9ac\ud130\ub7f4<\/strong> \ub610\ub294 <strong>\uc22b\uc790<\/strong> \uac12\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. \ub9ac\ud130\ub7f4\uc740 \uc9c0\uc815\ub41c \ud615\uc2dd\uc774\uc5b4\uc57c \ud569\ub2c8\ub2e4. \ub0a0\uc9dc-\uc2dc\uac04\uc758 \ud615\uc2dd\uc740 \ub2e4\uc74c\uc744 \uc0ac\uc6a9\ud558\uc5ec \uc124\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em>nls_date_format<\/em>, <em>nls_timestamp_format<\/em>, <em>NL_TIMESTAMP_TZ_FORMAT<\/em> \ubc0f <em>nls_date_language<\/em> \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uc544\ub798 \ud45c\uc5d0\ub294 \uc791\uc5c5 \uc608\uc2dc\uc640 \ud568\uaed8 \uc790\uc138\ud55c \ube44\uad50 \ub0b4\uc6a9\uc774 \ub098\uc640 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<h2>\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ub0a0\uc9dc \ud615\uc2dd<\/h2>\n<p><span style=\"font-weight: 400\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc5d0\uc11c\ub294 \ub0a0\uc9dc-\uc2dc\uac04\uc774 \uc870\uae08 \ub2e4\ub974\uac8c \ucc98\ub9ac\ub429\ub2c8\ub2e4. \ubaa8\ub4e0 \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uc800\uc7a5\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. <strong>\ubb38\uc790\uc5f4<\/strong> \ub97c \ub530\ub974\ub294 <strong>\ud655\uc7a5\ub41c ISO 8601 \ub0a0\uc9dc \uc2dc\uac04 \ud615\uc2dd<\/strong>. N1QL\uc5d0\ub294 \ub2e4\uc74c\uc774 \ud3ec\ud568\ub429\ub2c8\ub2e4. <em>\ub0a0\uc9dc \uc2dc\uac04<\/em> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc774\ub7ec\ud55c \uc624\ub77c\ud074 \ub0a0\uc9dc \ud615\uc2dd\uc758 \ubb38\uc790\uc5f4\uc744 \ucd94\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 <em>\ub0a0\uc9dc<\/em> \uadf8\ub9ac\uace0 <em>\uc2dc\uac04<\/em> \ub97c \ubc00\ub9ac\ucd08 \ub2e8\uc704\uc758 \uc720\ub2c9\uc2a4 \ud0c0\uc784\uc2a4\ud0ec\ud504\ub85c \ud45c\uc2dc\ud560 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc774\ub294 \uae30\ubcf8\uc801\uc73c\ub85c \uc785\ub825 \ub0a0\uc9dc \ubc0f \uc2dc\uac04\uc758 \ud615\uc2dd\uc774 \uc785\ub825 \ub0a0\uc9dc \ubc0f \uc2dc\uac04\uc758 \uac12\uc5d0 \ub530\ub77c \ubcc0\uacbd\ub420 \uc218 \uc788\ub294 Oracle\uacfc \ub2ec\ub9ac <em>nls_date_format<\/em> \uadf8\ub9ac\uace0 <em>nls_timestamp_format<\/em>\uc758 \ub0a0\uc9dc \ud615\uc2dd\uc740 \uc5c4\uaca9\ud55c \uc9d1\ud569\uc744 \ub530\ub985\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc608\ub97c \ub4e4\uc5b4 \uc624\ub77c\ud074 \ud0c0\uc784\uc2a4\ud0ec\ud504 \ud615\uc2dd\uc785\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em>'2008-dec-25 17:30'<\/em> \ub294 \uc720\ud6a8\ud55c \ub0a0\uc9dc\uc774\uba70 <em>nls_date_format='yyyy-mon-dd hh24:mi'<\/em><\/p>\n<p><span style=\"font-weight: 400\">\uadf8\ub7ec\ub098 Couchbase\uc5d0\uc11c \ub3d9\uc77c\ud55c \uac12\uc744 \ud45c\ud604\ud558\ub824\uba74 \uc0ac\uc6a9\uc790\ub294 \uc8fc\uc5b4\uc9c4 \uac12 \uc911 \ud558\ub098\ub97c \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/datefun.html\">\ub0a0\uc9dc \ud568\uc218 \ud615\uc2dd<\/a>.<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">\uc608\ub97c \ub4e4\uc5b4, 2008-12-25 17:30:00<\/span><\/em><\/p>\n<h3>\uc2dc\uac04 \uc815\ubc00\ub3c4<\/h3>\n<p><span style=\"font-weight: 400\">\uc624\ub77c\ud074\uc5d0\uc11c, <\/span><em><span style=\"font-weight: 400\">fractional_seconds_precision<\/span><\/em><span style=\"font-weight: 400\"> \ub294 \uc120\ud0dd \uc0ac\ud56d\uc774\uba70 \ubd84\uc218 \ubd80\ubd84\uc758 \uc790\ub9bf\uc218\ub97c \uc9c0\uc815\ud569\ub2c8\ub2e4. <em>SECOND<\/em> \ub0a0\uc9dc\/\uc2dc\uac04 \ud544\ub4dc\ub97c \uc785\ub825\ud569\ub2c8\ub2e4. \uc22b\uc790(0~9)\ub85c \uc785\ub825\ud560 \uc218 \uc788\uc73c\uba70 \uae30\ubcf8\uac12\uc740 6\uc785\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc608\ub97c \ub4e4\uc5b4 Oracle\uc5d0\uc11c \ub0a0\uc9dc-\uc2dc\uac04 \ud615\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc774 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">\ud0c0\uc784\uc2a4\ud0ec\ud504 'yyyy-mm-dd hh24:mi:ss.fff'<\/span> <\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc774\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud0c0\uc784\uc2a4\ud0ec\ud504\ub97c \uc815\uc758\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4: <\/span><em><span style=\"font-weight: 400\">&#8216;2006-01-02 15:04:05.999&#8217;<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\"><a href=\"https:\/\/www.couchbase.com\/blog\/ko\/products\/n1ql\/\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 N1QL<\/a> \ub294 \uc624\ub77c\ud074\uacfc \uc720\uc0ac\ud55c \ubd84\uc218 \ucd08\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. \uc774\ub294 \ud615\uc2dd\uc744 \uc0ac\uc6a9\ud560 \ub54c \ud45c\uc2dc\ub429\ub2c8\ub2e4:<\/span><span style=\"font-weight: 400\">\u00a0<em>\u201c2006-01-02T15:04:05.999\u201d<\/em>. <\/span><span style=\"font-weight: 400\">\ud558\uc9c0\ub9cc,<\/span> <span style=\"font-weight: 400\">N1QL\uc740 3\uc790\ub9ac \uc815\ubc00\ub3c4(\ub098\ub178\ucd08 \uc815\ubc00\ub3c4)\ub97c \uc9c0\uc6d0\ud558\uba70 Oracle\uc740 \ucd5c\ub300 9\uc790\ub9ac \uc18c\uc218\uc810 \ucd08 \uc815\ubc00\ub3c4\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc989, \ub0a0\uc9dc\ub97c \uc9c0\uc815\ud558\uba74: <\/span><span style=\"font-weight: 400\"><em>\u201c2006-01-02T15:04:05.999123456\u201d<\/em>\ub97c \uc785\ub825\ud558\uba74 N1QL\uc774 3\uc790\ub9ac\ub85c \ubc18\uc62c\ub9bc\ub418\uc5b4 \ubc18\ud658\ub429\ub2c8\ub2e4: <em>\u201c2006-01-02T15:04:05.999\u201d<\/em>.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N1QL\uc758 \uacbd\uc6b0, <\/span><\/p>\n<pre class=\"lang:default decode:true\" title=\"N1QL\">SELECT STR_TO_TZ(\"2006-01-02T15:04:05.999123456\", 'America\/Los_Angeles') as west;\r\n \u00a0\u00a0\u00a0\"results\": [\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"west\": \"2006-01-02T15:04:05.999\"\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n \u00a0\u00a0\u00a0]<\/pre>\n<p><span style=\"font-weight: 400\">Oracle\uc758 \uacbd\uc6b0,<\/span><\/p>\n<pre class=\"nums:false lang:default decode:true\">SELECT TO_TIMESTAMP('25-DEC-2008 01:00:00.336123456', 'dd-mon-yyyy hh:mi:ss.ff') as D from dual;\r\n\r\n&gt; D\r\n&gt; 2008-12-25 01:00:00.336123456<\/pre>\n<p><span style=\"font-weight: 400\">N1QL\uc744 \uc0ac\uc6a9\ud558\uc5ec 9\uc790\ub9ac \uc774\uc0c1\uc758 \uc22b\uc790\ub97c \uc9c0\uc815\ud558\uba74 \ub0a0\uc9dc-\uc2dc\uac04 \ud568\uc218\ub294 null\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. <\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT STR_TO_TZ(\"2006-01-02T15:04:05.9991234567\", 'America\/Los_Angeles') as west;\r\n\u00a0\u00a0\u00a0\"results\": [\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"west\": null\r\n \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n \u00a0\u00a0\u00a0]<\/pre>\n<p><span style=\"font-weight: 400\">Oracle \ub0a0\uc9dc-\uc2dc\uac04 \ud615\uc2dd\uc758 \uacbd\uc6b0 \uc18c\uc218 \ucd08 \ubd80\ubd84\uc5d0 9\uc790\ub9ac \uc774\uc0c1\uc758 \uc22b\uc790\ub97c \uc785\ub825\ud558\uba74 \uc624\ub958\uac00 \ubc1c\uc0dd\ud569\ub2c8\ub2e4: <\/span><em><span style=\"font-weight: 400\">ORA-01830: \uc804\uccb4 \uc785\ub825 \ubb38\uc790\uc5f4\uc744 \ubcc0\ud658\ud558\uae30 \uc804\uc5d0 \ub0a0\uc9dc \ud615\uc2dd \uadf8\ub9bc\uc774 \ub05d\ub0a8<\/span><\/em><\/p>\n<h2>\uc624\ub77c\ud074\uacfc \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \ub0a0\uc9dc\/\uc2dc\uac04 \uc811\uadfc \ubc29\uc2dd \ube44\uad50<\/h2>\n<p><span style=\"font-weight: 400\">\ub2e4\uc74c \ud45c\uc5d0 Couchbase N1QL\uacfc Oracle\uc758 \ub0a0\uc9dc\/\uc2dc\uac04 \uc9c0\uc6d0 \ube44\uad50\uac00 \ub098\uc640 \uc788\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<div class=\"responsive-table\">\n<table>\n<tbody>\n<tr>\n<td><strong>Oracle \ub0a0\uc9dc \ubc0f \uc2dc\uac04 \ub370\uc774\ud130 \uc720\ud615<\/strong><\/td>\n<td><strong>\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ub0a0\uc9dc \uc2dc\uac04 \ud615\uc2dd \uc9c0\uc6d0<\/strong><\/td>\n<\/tr>\n<tr>\n<td><em><span style=\"font-weight: 400\">\ub0a0\uc9dc <\/span><\/em><span style=\"font-weight: 400\">\ub370\uc774\ud130 \uc720\ud615 F<\/span><span style=\"font-weight: 400\">\uc5d0 \uc758\ud574 \uc815\uc758\ub429\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">nls_date_format<\/span><\/em><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">nls_date_language<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc608\uc2dc: <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uadf8\ub9ac\uace0 <em>nls_date_format<\/em> \ub9e4\uac1c \ubcc0\uc218\ub97c \uc124\uc815\ud574\uc57c \ud569\ub2c8\ub2e4. <\/span><span style=\"font-weight: 400\">\ub97c \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218 \ud30c\uc77c\uc5d0 \ucd94\uac00\ud569\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">nls_date_format='yyyy-mon-dd'<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc0d8\ud50c \ub0a0\uc9dc:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">\ub0a0\uc9dc '2008-dec-25'<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc124\uc815\ud558\ub824\uba74 <em>nls_date_language<\/em> \ub9e4\uac1c\ubcc0\uc218 <\/span><span style=\"font-weight: 400\">\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em>\uc138\uc158 \ubcc0\uacbd<\/em> \ubb38\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"lang:default decode:true\">ALTER SESSION SET NLS_DATE_LANGUAGE = FRENCH;\r\n\r\nSELECT TO_CHAR(SYSDATE, 'Day:Dd Month yyyy') \r\nFROM DUAL;\r\n\r\nTO_CHAR(SYSDATE,'DAY:DDMONTHYYYY')\r\n--------------------------------------\r\nLundi :21 Ao\u00fbt \u00a0\u00a0\u00a0\u00a0\u00a02017<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">N1QL\uc5d0\uc11c\ub294 \ud2b9\uc815 \ub0a0\uc9dc\/\uc2dc\uac04\/<\/span><span style=\"font-weight: 400\">\ud0c0\uc784\uc2a4\ud0ec\ud504 \ub370\uc774\ud130 \uc720\ud615\uc785\ub2c8\ub2e4. \ubaa8\ub450 ISO 8601 \ud655\uc7a5 \ud615\uc2dd\uc758 JSON \ubb38\uc790\uc5f4\ub85c \ud45c\uc2dc\ub418\uba70 \ub0a0\uc9dc \uc2dc\uac04 \uc870\uc791 \ubc0f \uc0b0\uc220 \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc870\uc791\ub429\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\ucc38\uc870 <\/span><a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/datefun.html\"><span style=\"font-weight: 400\">\ubb38\uc11c<\/span><\/a><span style=\"font-weight: 400\"> \ub97c \ud074\ub9ad\ud574 \uc804\uccb4 \ubaa9\ub85d\uc744 \ud655\uc778\ud558\uc138\uc694.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ud5c8\uc6a9\ub418\ub294 \ub0a0\uc9dc \ud615\uc2dd*:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">YYYY-MM-DD<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc608\uc2dc:<\/span><\/p>\n<pre class=\"lang:default decode:true\">{\r\n\u00a0\"Date\" : \"2008-12-25\"\r\n}<\/pre>\n<p><span style=\"font-weight: 400\">Couchbase\/N1QL\uc5d0\uc11c \ub0a0\uc9dc\ub294 \uc77c, \uc6d4, \uc5f0\ub3c4\uc758 \uc22b\uc790 \ud615\uc2dd\uc774 \ud3ec\ud568\ub41c \ud2b9\uc815 \ud615\uc2dd\uc73c\ub85c \ud45c\uc2dc\ub418\uc5b4\uc57c \ud569\ub2c8\ub2e4. <\/span><\/p>\n<p>\uc785\ub825 \ud615\uc2dd\uacfc \uc77c\uce58\ud558\uc9c0 \uc54a\ub294 \ubaa8\ub4e0 \ub0a0\uc9dc\uc758 \uacbd\uc6b0 \uae30\ubcf8 \ud615\uc2dd\uc758 \uc785\ub825 \ub0a0\uc9dc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4:<\/p>\n<p style=\"padding-left: 40px\"><em>YYYY-MM-DDThh:mm:ss.sTZD<\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc0ac\uc6a9 <em>\ub0a0\uc9dc_\ud3ec\ub9f7_str<\/em> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub0a0\uc9dc \ud615\uc2dd\uc744 <em>YYYY-MM-DD<\/em> \uc5d0 <\/span><span style=\"font-weight: 400\"><em>'YYYY-MON-DD'<\/em>\u00a0<\/span><\/p>\n<pre class=\"lang:default decode:true\">select date_format_str('2008-12-25',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0'1111-DEC-12') D;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": \"2008-12-25T00:00:00-08:00\"\r\n\u00a0\u00a0\u00a0\u00a0}\r\n]\r\n<\/pre>\n<p><span style=\"font-weight: 400\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub294 \ub2e4\uc74c\ub9cc \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <strong>ISO \ud655\uc7a5 \ub0a0\uc9dc \ud615\uc2dd<\/strong>. \uc5ec\ub7ec \uc5b8\uc5b4\ub85c \ub41c \uc22b\uc790\uac00 \uc544\ub2cc \ub0a0\uc9dc\ub294 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\"><em>\ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \ub370\uc774\ud130 \uc720\ud615 F<\/span><span style=\"font-weight: 400\">\uc5d0 \uc758\ud574 \uc815\uc758\ub429\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">nls_timestamp_format<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\ub2e4\uc74c \uac12\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span><em><span style=\"font-weight: 400\">nls_timestamp_format<\/span><\/em><span style=\"font-weight: 400\"> \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218 \ud30c\uc77c\uc5d0\uc11c \uc124\uc815\ud558\uba74 \ub429\ub2c8\ub2e4. <\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">nls_timestamp_format = 'yyyy-mm-dd hh:mi:ss.ff'<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc6b0\ub9ac\ub294 <em>TO_TIMESTAMP<\/em> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc785\ub825\uc744 \ubcc0\ud658\ud569\ub2c8\ub2e4. <em>\ub0a0\uc9dc-\uc2dc\uac04<\/em> \uc5d0 <em>\ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \ub370\uc774\ud130 \uc720\ud615.<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT \r\nTO_TIMESTAMP('25-DEC-2008 01:00:00.336', \r\n'dd-mon-yyyy hh:mi:ss.ff') from dual;\r\n\r\nTO_TIMESTAMP('25-DEC-200801:00:00.336',\r\n'DD-MON-YYYYHH:MI:SS.FF')\r\n---------------------------------\r\n2008-12-25 01:00:00.336<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">date\uc640 \ud568\uc218\ub294 \ub3d9\uc77c\ud558\uc9c0\ub9cc \uc785\ub825 \ub0a0\uc9dc \ud615\uc2dd \uc785\ub825 \uc778\uc218\uac00 \ub2e4\ub985\ub2c8\ub2e4. \uc774 \uc778\uc218\ub294 \uba85\uc2dc\uc801\uc73c\ub85c \uc81c\uacf5\ud574\uc57c \ud569\ub2c8\ub2e4.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">\ud0c0\uc784\uc2a4\ud0ec\ud504 \uad6c\uc131 \uc694\uc18c\uc640 \ud568\uaed8 \ub0a0\uc9dc \ud615\uc2dd\uc785\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">YYYY-MM-DD hh:mm:ss<br \/>\n<\/span><\/em><em><span style=\"font-weight: 400\">YYYY-MM-DDThh:mm:ss<br \/>\n<\/span><\/em><em><span style=\"font-weight: 400\">YYYY-MM-DD hh:mm:ss.s<br \/>\n<\/span><\/em><em style=\"font-family: inherit;font-size: inherit\">YYYY-MM-DDThh:mm:ss.s<\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc2dc\uac04 \uae30\ubc18 \ud615\uc2dd:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">hh:mm:ss<br \/>\n<\/span><span style=\"font-weight: 400\">Hh:mm:ss.s<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub294 \ub098\ub178\ucd08 \ub2e8\uc704\uc758 \uc815\ubc00\ub3c4\ub97c \uc9c0\uc6d0\ud569\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\ndate_format_str('2008-12-25T01:00:00.336', \r\n'1111-DEC-12 01:00:00.00') D;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": \"2008-12-25T01:00:00.336-08:00\"\r\n\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\ub370\uc774\ud130 \uc720\ud615:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">\uc2dc\uac04\ub300\uac00 \ud3ec\ud568\ub41c \ud0c0\uc784\uc2a4\ud0ec\ud504<br \/>\n<\/span><\/em><em><span style=\"font-weight: 400\">\ud604\uc9c0 \uc2dc\uac04\ub300\uac00 \ud3ec\ud568\ub41c \ud0c0\uc784\uc2a4\ud0ec\ud504<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc5d0 \uc758\ud574 \uc815\uc758\ub41c \ud615\uc2dd\uc785\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">NL_TIMESTAMP_TZ_FORMAT<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\ub2e4\uc74c \uac12\uc744 \uc9c0\uc815\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span><em><span style=\"font-weight: 400\">NL_TIMESTAMP_TZ_FORMAT<\/span><\/em><span style=\"font-weight: 400\"> \ucd08\uae30\ud654 \ub9e4\uac1c\ubcc0\uc218 \ud30c\uc77c\uc5d0\uc11c \uc124\uc815\ud558\uba74 \ub429\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">nls_timestamp_tz_format = 'yyyy-mm-dd hh:mi:ss.ff tzh:tzm'<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc6b0\ub9ac\ub294 <em>to_timestamp_tz<\/em> \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc785\ub825 \ub0a0\uc9dc\/\uc2dc\uac04\uc744 \uc2dc\uac04\ub300 \ub370\uc774\ud130 \uc720\ud615\uc774 \uc788\ub294 \ud0c0\uc784\uc2a4\ud0ec\ud504\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4. \uc785\ub825\ub41c \ud45c\uc900 \uc2dc\uac04\ub300\ub97c \uc720\uc9c0\ud569\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT TO_CHAR(TO_TIMESTAMP_TZ\r\n('2008-12-25, 01:00:00.336 -08:00', \r\n'yyyy-mm-dd hh:mi:ss.ff TZR')) FROM DUAL;\r\n\r\nTO_CHAR(TO_TIMESTAMP_TZ\r\n('2008-12-25,01:00:00.336-08:00',\r\n'YYYY-MM-DDHH:MI:SS.FFTZR'))\r\n--------------------------------------\r\n25-DEC-08 01.00.00.336000000 AM -08:00<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\ud615\uc2dd\uc758 \ub0a0\uc9dc\/\uc2dc\uac04 \uad6c\uc131 \uc694\uc18c\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">YYYY-MM-DDThh:mm:ssTZD<br \/>\n<\/span><span style=\"font-weight: 400\">YYYY-MM-DD hh:mm:ssTZD<br \/>\n<\/span><span style=\"font-weight: 400\">YYYY-MM-DDThh:mm:ss.sTZD<br \/>\n<\/span><span style=\"font-weight: 400\">YYYY-MM-DD hh:mm:ss.sTZD<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\ud0c0\uc784\uc2a4\ud0ec\ud504 \uae30\ubc18 \ud615\uc2dd:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">hh:mm:ss.sTZD<br \/>\n<\/span><\/em><em><span style=\"font-weight: 400\">hh:mm:ssTZD<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">N1QL\uc5d0\ub294 \ud2b9\uc815 \ud615\uc2dd \uc678\uc5d0\ub3c4 \ub2e4\uc74c\uacfc \uac19\uc740 \ud2b9\uc815 \uc2dc\uac04\ub300 \uae30\ub2a5\ub3c4 \uc788\uc2b5\ub2c8\ub2e4. <em>\ubb38\uc790\uc5f4\uc744 \uc2dc\uac04\ub300\ub85c<\/em> <em>STR_TO_TZ<\/em> \uc785\ub825 \ub0a0\uc9dc\ub97c \uc9c0\uc815\ub41c \uc2dc\uac04\ub300\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4. <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/datefun.html\">\ud45c\uc900 \uc2dc\uac04\ub300 \uc870\uc791 \uae30\ub2a5\uc5d0 \ub300\ud55c \uc124\uba85\uc11c\ub97c \ucc38\uc870\ud558\uc138\uc694.<\/a><\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT \r\nSTR_TO_TZ('2008-12-25T01:00:00.336-08:00', \r\n'America\/Los_Angeles') as west;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"west\": \"2008-12-25T01:00:00.336-08:00\"\r\n\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]\r\n<\/pre>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><em>\ud45c 1 - \uc624\ub77c\ud074 \ub0a0\uc9dc\/\uc2dc\uac04 \uc720\ud615\uacfc N1QL ISO \ud45c\uc900 \uc2dc\uac04\ub300 \ubc0f \ub0a0\uc9dc \ud615\uc2dd \ube44\uad50<\/em><\/p>\n<\/div>\n<p style=\"padding-left: 40px\"><span style=\"font-weight: 400\">* <\/span><span style=\"font-weight: 400\">\uc624\ub77c\ud074\uacfc N1QL \ubaa8\ub450 \uc9c0\uc815\ub41c \uc2dc\uac04\ub300\uc5d0 \uc11c\uba38\ud0c0\uc784\uc774 \uc801\uc6a9\ub418\uace0 \uc788\ub294\uc9c0 \uc5ec\ubd80\ub97c \uc790\ub3d9\uc73c\ub85c \uacb0\uc815\ud558\uace0 \ud574\ub2f9 \ud604\uc9c0 \uc2dc\uac04\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. \u00a0<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-weight: 400\">** N1QL\uc5d0\uc11c \ub0a0\uc9dc \ud615\uc2dd\uc744 \ub2e4\ub8f0 \ub54c\ub294 \ub0a0\uc9dc \uc2dc\uac04 \ubb38\uc790\uc5f4\uc758 \uac01 \uad6c\uc131 \uc694\uc18c\uac00 \uc720\ud6a8\ud55c <strong>\uc22b\uc790 <\/strong>\uac12\uc744 \uc0ac\uc6a9\ud574\uc57c \ud569\ub2c8\ub2e4. \ub610\ud55c \ub0a0\uc9dc\/\uc2dc\uac04 \ubb38\uc790\uc5f4\uc758 \ub0a0\uc9dc \uad6c\uc131 \uc694\uc18c\ub294 \ub300\uc2dc \"<em>&#8211;<\/em>\", \uc2dc\uac04 \uad6c\uc131 \uc694\uc18c\ub294 \ucf5c\ub860\uc73c\ub85c \uad6c\ubd84\ud574\uc57c \ud568 \"<em>:<\/em>\". \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uc720\ud6a8\ud55c \ub0a0\uc9dc \uac1d\uccb4\uac00 \uc544\ub2d9\ub2c8\ub2e4.<\/span><\/p>\n<hr \/>\n<p><a href=\"https:\/\/resources.couchbase.com\/c\/relational-no-sql-wp?x=Y7B0ca#page=1\"><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-14421\" src=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2017\/09\/image_2023-05-22_153949246-1024x622.png\" alt=\"Moving from relational to NoSQL: How to get started from Oracle\" width=\"283\" height=\"172\" srcset=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/image_2023-05-22_153949246-1024x622.png 1024w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/image_2023-05-22_153949246-300x182.png 300w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/image_2023-05-22_153949246-768x467.png 768w, https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/image_2023-05-22_153949246.png 1218w\" sizes=\"auto, (max-width: 283px) 100vw, 283px\" \/><\/a><strong>\uad00\ub828 \ub9ac\uc18c\uc2a4<\/strong><\/p>\n<p>JSON\uc758 \uc7a5\uc810\uc740 \ub0a0\uc9dc\/\uc2dc\uac04 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\ub294 \ub370 \ub2e4\uc591\ud558\uace0 \uc720\uc5f0\ud55c \uc2a4\ud0c0\uc77c\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\uace0, \uac04\ub2e8\ud55c \ud568\uc218\ub97c \uc0ac\uc6a9\ud574 \ud544\uc694\ud55c \uc2dc\uc810\uc5d0 \ud544\uc694\ud55c \uc815\ubcf4\ub97c \uad6c\uc131\ud558\uac70\ub098 \ucd94\ucd9c\ud560 \uc218 \uc788\ub2e4\ub294 \uc810\uc785\ub2c8\ub2e4. Couchbase NoSQL\uc5d0\uc11c\ub294 \uc5c4\uaca9\ud55c \uc2a4\ud0a4\ub9c8\uac00 \ud544\uc694\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c \ub808\uac70\uc2dc RDBMS \uc194\ub8e8\uc158\ubcf4\ub2e4 \uc720\uc5f0\ud569\ub2c8\ub2e4. <a href=\"https:\/\/resources.couchbase.com\/c\/relational-no-sql-wp?x=Y7B0ca#page=1\">\ubc31\uc11c\ub97c \uc77d\uace0 \uc790\uc138\ud788 \uc54c\uc544\ubcf4\uae30<\/a>.<\/p>\n<p>&nbsp;<\/p>\n<hr \/>\n<h2>\uc624\ub77c\ud074 \ubc0f \uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ub0a0\uc9dc\/\uc2dc\uac04 \uad6c\uc131 \uc694\uc18c<\/h2>\n<p><span style=\"font-weight: 400\">\ubaa8\ub4e0 \ub0a0\uc9dc\/\uc2dc\uac04 \uc720\ud615\uc5d0 \ub300\ud574 Oracle\uacfc N1QL\uc740 \uc785\ub825 \ub0a0\uc9dc\uc5d0 \ub300\ud574 \uc11c\ub85c \ub2e4\ub978 \ud544\ub4dc\uc5d0 \ucd94\uac00 \uc815\ubcf4\ub97c \uc800\uc7a5\ud569\ub2c8\ub2e4. \uc774\ub97c \ud1b5\ud574 \uc0ac\uc6a9\uc790\ub294 \ub0a0\uc9dc\uc5d0 \ub300\ud55c \ud2b9\uc815 \uc815\ubcf4\ub97c \ucd94\ucd9c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc624\ub77c\ud074\uc758 \ub0a0\uc9dc\/\uc2dc\uac04 \ud544\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <em>CENTURY<\/em>, <em>\uc5f0\ub3c4<\/em>, <em>\uc6d4<\/em>, <em>DAY<\/em>, <em>\uc2dc\uac04,<\/em> <em>MINUTE<\/em> \uadf8\ub9ac\uace0 <em>SECOND<\/em>. . <em>\ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \ub370\uc774\ud130 \uc720\ud615\uc740 \ucd08\ub97c \ubd84\uc218 \ucd08\ub85c \ub098\ud0c0\ub0b4\uba70, \uadf8 \uc815\ubc00\ub3c4\ub294 <em>fractional_seconds_precision<\/em> \ub9e4\uac1c\ubcc0\uc218. \ub610\ud55c \ub2e4\uc74c\uacfc \uac19\uc740 \ud544\ub4dc\ub3c4 \ud3ec\ud568\ub429\ub2c8\ub2e4. <em>\uc2dc\uac04\ub300_\uc2dc\uac04<\/em>, <em>\uc2dc\uac04\ub300_\ubd84<\/em>, <em>\uc2dc\uac04\ub300_\uc9c0\uc5ed<\/em> \uadf8\ub9ac\uace0 <em>TIMEZONE_ABBR<\/em>. \ub0b4\ubd80\uc801\uc73c\ub85c \uc624\ub77c\ud074 \ud0c0\uc784\uc2a4\ud0ec\ud504\ub97c \ub0a0\uc9dc \uac12\uc73c\ub85c \ubcc0\ud658\ud569\ub2c8\ub2e4. \uc2dc\uac04 \uad6c\uc131 \uc694\uc18c\uc758 \uae30\ubcf8\uac12\uc740 \uc790\uc815\uc774\uace0 \ub0a0\uc9dc \uad6c\uc131 \uc694\uc18c\uc758 \uae30\ubcf8 \ub0a0\uc9dc\ub294 \ud604\uc7ac \ub2ec\uc758 \uccab\ub0a0\uc785\ub2c8\ub2e4. A <em>\ub0a0\uc9dc<\/em> \ub370\uc774\ud130 \uc720\ud615\uc740 \ub0a0\uc9dc\uc640 \uc2dc\uac04 \uc815\ubcf4\ub97c \ubaa8\ub450 \uc800\uc7a5\ud569\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc624\ub77c\ud074\uc774 \uc9c0\uc6d0\ud558\ub294 \ud544\ub4dc \uc678\uc5d0\ub3c4 <em>\ub0a0\uc9dc<\/em> \uadf8\ub9ac\uace0 <em>\uc2dc\uac04<\/em> \ub370\uc774\ud130 \uc720\ud615, N1QL\uc740 \ub2e4\uc74c\uc744 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <em>\ubc00\ub808\ub2c8\uc5c4<\/em>, <em>DECADE<\/em>, <em>\ubd84\uae30<\/em>, <em>WEEK<\/em> \uadf8\ub9ac\uace0 <em>\ubc00\ub9ac\ucd08<\/em>. \uc774\ub7ec\ud55c \ud544\ub4dc\uc758 \uac12\uc740 \uae30\ubcf8 \uc0b0\uc220\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub0b4\ubd80\uc801\uc73c\ub85c \uacc4\uc0b0\ub429\ub2c8\ub2e4. N1QL\uc740 \ub2e4\uc74c\uc744 \uc9c0\uc6d0\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. <em>\uc2dc\uac04\ub300_\uc9c0\uc5ed<\/em> \uadf8\ub9ac\uace0 <em>TIMEZONE_ABBR<\/em> \ud544\ub4dc. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uac01 \ud544\ub4dc\uc5d0 \ub300\ud55c \uc790\uc138\ud55c \ube44\uad50\ub294 \uc544\ub798 \ud45c\uc5d0 \ub098\uc640 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc624\ub77c\ud074\uc758 \ud0c0\uc784\uc2a4\ud0ec\ud504 \ud615\uc2dd \uc608\uc81c\uc5d0 \ub300\ud55c \ub2e4\uc74c \uc0d8\ud50c \ud589\uc744 \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4:<\/span><\/p>\n<pre class=\"nums:false lang:default decode:true\">create table t1 (date_purchased timestamp with time zone );\r\ninsert into t1 values (TIMESTAMP '2008-12-25 01:00:00.336 PST');\r\n\r\n&gt; t1 date_purchased\r\n&gt; 2008-12-25,01:00:00.336-08:00<\/pre>\n<p><span style=\"font-weight: 400\">\ub77c\ub294 \uc774\ub984\uc758 \ubc84\ud0b7\uc5d0 \uc788\ub294 \ud574\ub2f9 Couchbase \ubb38\uc11c\ub97c \uace0\ub824\ud574 \ubcf4\uaca0\uc2b5\ub2c8\ub2e4.\u00a0<em>bucket1<\/em>:<\/span><\/p>\n<pre class=\"lang:default decode:true\">create primary index on bucket1;\r\nInsert into bucket1 values (\"23\", {\"date_purchased\":\"2008-12-25T01:00:00.336-08:00\"});\r\n\r\nBucket1 - Document id : 23\r\n{ \r\n \u00a0\"date_purchased\":\"2008-12-25T01:00:00.336-08:00\"\r\n}<\/pre>\n<p><span style=\"font-weight: 400\">\uadf8\ub9ac\uace0 <em>TO_CHAR('CC' ), <\/em>\ub97c \uccab \ubc88\uc9f8 \uc778\uc218\ub85c \uc0ac\uc6a9\ud558\uace0 <em>\ubc1c\ucdcc<\/em> \ud568\uc218\ub294 \uc624\ub77c\ud074\uc5d0\uc11c \ub0a0\uc9dc-\uc2dc\uac04 \ud544\ub4dc \uac12\uc744 \uac80\uc0c9\ud558\ub294 \ub370 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">N1QL\uc758 \uacbd\uc6b0 \ub450 \uac00\uc9c0 \uae30\ub2a5\uc774 \uc788\uc2b5\ub2c8\ub2e4. <em>DATE_PART_STR<\/em> \ub610\ub294 <em>\ub0a0\uc9dc_\ud30c\ud2b8_\ubc00\ub9ac\uc2a4<\/em> \ub0a0\uc9dc\uac00 JSON \ubb38\uc790\uc5f4\ub85c \ud45c\uc2dc\ub418\ub294\uc9c0 \ub610\ub294 \uc22b\uc790 \ubc00\ub9ac\ucd08\ub85c \ud45c\uc2dc\ub418\ub294\uc9c0\uc5d0 \ub530\ub77c \ub2e4\ub985\ub2c8\ub2e4. \uc774\ub7ec\ud55c \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc544\ub798 \ub098\uc5f4\ub41c \uac01 \ub0a0\uc9dc-\uc2dc\uac04 \uad6c\uc131 \uc694\uc18c\uc5d0 \ub300\ud55c \uc608\uc81c\ub97c \uc81c\uacf5\ud569\ub2c8\ub2e4.<\/span><\/p>\n<h3>\uc624\ub77c\ud074 \ubc0f \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\uc758 \ubaa8\ub4e0 \ub0a0\uc9dc \uc2dc\uac04 \uad6c\uc131 \uc694\uc18c \uc694\uc57d<\/h3>\n<div class=\"responsive-table\">\n<table>\n<tbody>\n<tr>\n<td><strong>\ub0a0\uc9dc-\uc2dc\uac04 \uad6c\uc131 \uc694\uc18c<\/strong><\/td>\n<td><strong>Oracle <\/strong><\/td>\n<td><strong>N1QL<\/strong><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">CENTURY<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select TO_CHAR(date_purchased, \r\n'CC') from t1;\r\n\r\nTO_CHAR(DATE_PURCHASED,'CC')\r\n\r\n----------------------\r\n\r\n21<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"century\") as C from bucket1;\r\n\r\n\"results\": [\r\n      {\r\n        \"C\": 21\r\n      }\r\n]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\uc5f0\ub3c4<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(year \r\nFROM date_purchased) \r\n\"D\" from t1;\r\n\r\nD\r\n--------\r\n2008<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"year\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": 2008\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\uc6d4<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(month \r\nFROM date_purchased) \"D\" from t1;\r\n\r\nD\r\n--------\r\n12<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"month\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": 12\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">DAY<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(day \r\nFROM date_purchased) \r\n\"D\" from t1;\r\n\r\nD\r\n--------\r\n25<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"day\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": 25\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\uc2dc\uac04<\/span><\/p>\n<p><b>(\ub2e4\ub978 \ub3d9\uc791)<\/b><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(hour \r\nFROM date_purchased) \r\n\"D\" from t1;\r\n\r\nD\r\n--------\r\n9<\/pre>\n<p><span style=\"font-weight: 400\">\uc624\ub77c\ud074\uc740 \uc785\ub825 \ud0c0\uc784\uc2a4\ud0ec\ud504\uc758 \ud45c\uc900 \uc2dc\uac04\ub300 \uad6c\uc131 \uc694\uc18c\ub97c \uace0\ub824\ud569\ub2c8\ub2e4.<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"hour\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": 1\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<p><span style=\"font-weight: 400\">\uadf8\ub9ac\uace0 <\/span><b>\ucc28\uc774<\/b><span style=\"font-weight: 400\"> \uac00 \uacb0\uacfc\uc5d0 \ud45c\uc2dc\ub418\ub294 \uc774\uc720\ub294 N1QL\uc774 \uc785\ub825 \ud0c0\uc784\uc2a4\ud0ec\ud504\uc758 \ud45c\uc900 \uc2dc\uac04\ub300 \uad6c\uc131 \uc694\uc18c\ub97c \uace0\ub824\ud558\uc9c0 \uc54a\uae30 \ub54c\ubb38\uc785\ub2c8\ub2e4.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">MINUTE<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(minute\r\n FROM date_purchased) \r\n\"D\" from t1;\r\n\r\nD\r\n--------\r\n0<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"minute\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">SECOND<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(second \r\nFROM date_purchased) \r\n\"D\" from t1;\r\n\r\nD\r\n--------\r\n0,3360<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"second\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<p><span style=\"font-weight: 400\">\ubd84\uc218 \ubd80\ubd84\uc740 \ubc00\ub9ac\ucd08\ub97c \ucc38\uc870\ud558\uc138\uc694.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\uc2dc\uac04\ub300_\uc2dc\uac04<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(timezone_hour \r\nFROM date_purchased) \"D\" from t1;\r\n\r\nD\r\n--------\r\n-8<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"timezone_hour\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": -8\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\uc2dc\uac04\ub300_\ubd84<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(timezone_minute \r\nFROM date_purchased) \"D\" from t1;\r\n\r\nD\r\n--------\r\n0<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"timezone_minute\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": 0\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\uc2dc\uac04\ub300_\uc9c0\uc5ed<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(timezone_region \r\nFROM date_purchased) \"D\" from t1;\r\n\r\nD\r\n--------\r\nPST<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">TIMEZONE_ABBR<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT EXTRACT(timezone_abbr \r\nFROM date_purchased) \"D\" from t1;\r\n\r\nD\r\n--------\r\nPST<\/pre>\n<p>&nbsp;<\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\ud45c\uc900 \uc2dc\uac04\ub300(UTC\uc5d0\uc11c \uc624\ud504\uc14b)<\/span><\/td>\n<td><span style=\"font-weight: 400\">(\ud544\ub4dc\uac00 \uc544\ub2cc \ub370\uc774\ud130 \uc720\ud615 \uc790\uccb4)<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"timezone\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": -28800\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<p><span style=\"font-weight: 400\">\uc5ec\uae30\uc11c \uc22b\uc790\ub294 \uc2dc\uac04\ub300(\ucd08)\ub97c \ub098\ud0c0\ub0c5\ub2c8\ub2e4.<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\ubc00\ub808\ub2c8\uc5c4 <\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><b>\ubc00\ub808\ub2c8\uc5c4<\/b><em><span style=\"font-weight: 400\"> = (\uc5f0\ub3c4\/1000) + 1 \u00a0<\/span><\/em><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"millennium\") as D from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": 3\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">DECADE<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><b>10\ub144<\/b><em><span style=\"font-weight: 400\"> = \ub144 \/ 10<\/span><\/em><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"decade\") as D from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": 200\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\ubd84\uae30<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><b>\ubd84\uae30<\/b><em><span style=\"font-weight: 400\"> = (\uc6d4 + 2) \/ 3<\/span><\/em><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"quarter\") as D from bucket1;\r\n\r\n\u00a0\u00a0\u00a0\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": 4\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">WEEK <\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><b>\uc8fc<\/b><span style=\"font-weight: 400\"><em> = int(math.Ceil(float64(YearDay) \/ 7.0))<\/em><\/span><\/p>\n<p><span style=\"font-weight: 400\"><em>YearDay<\/em> \ub294 \uc724\ub144\uc774 \uc544\ub2cc \uacbd\uc6b0 1~365, \uc724\ub144\uc778 \uacbd\uc6b0 1~366 \ubc94\uc704\uc5d0\uc11c \uc2dc\uac04\uc73c\ub85c \uc9c0\uc815\ub41c \uc5f0\ub3c4\uc758 \ub0a0\uc9dc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.  (\ucc38\uc870 <\/span><a href=\"https:\/\/golang.org\/pkg\/time\/\"><span style=\"font-weight: 400\">\uace8\ub791 \ud0c0\uc784 \ud328\ud0a4\uc9c0<\/span><\/a><span style=\"font-weight: 400\">)<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"week\") as D from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": 52\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\ubc00\ub9ac\ucd08<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><b>\ubc00\ub9ac\ucd08<\/b><em><span style=\"font-weight: 400\"> = \ub098\ub178\ucd08 \/ 10<\/span><span style=\"font-weight: 400\">6<\/span><\/em><span style=\"font-weight: 400\"><br \/>\n\ub97c \uc815\uc218\ub85c<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"millisecond\") as D from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": 336\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">ISO_YEAR<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><span style=\"font-weight: 400\">Iso_year = \uc785\ub825 \ud0c0\uc784\uc2a4\ud0ec\ud504\uc758 ISO 8601 \uc5f0\ub3c4\uc785\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"iso_year\") as C from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"C\": 2008\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">ISO_WEEK<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><span style=\"font-weight: 400\">Iso_week = \uc785\ub825 \ud0c0\uc784\uc2a4\ud0ec\ud504\uc758 ISO 8601 \uc8fc\uc785\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc8fc \ubc94\uc704\ub294 \ubcf4\ud1b5 1\uc5d0\uc11c 53\uae4c\uc9c0\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4 n\ub144\ub3c4\uc758 1\uc6d4 1\uc77c\ubd80\ud130 1\uc6d4 3\uc77c\uae4c\uc9c0\ub294 n-1\ub144\ub3c4\uc758 52\uc8fc\ucc28 \ub610\ub294 53\uc8fc\ucc28\uc5d0 \uc18d\ud560 \uc218 \uc788\uc73c\uba70, 12\uc6d4 29\uc77c\ubd80\ud130 31\uc77c\uae4c\uc9c0\ub294 n+1\ub144\ub3c4\uc758 1\uc8fc\ucc28\uc5d0 \uc18d\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"iso_week\") as D from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": 52\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">DAY_OF_YEAR(DOY)<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><span style=\"font-weight: 400\">Day_of_year \ub610\ub294 doy <em>= YearDay<\/em><\/span><\/p>\n<p><span style=\"font-weight: 400\"> \ucc38\uc870 <\/span><a href=\"https:\/\/golang.org\/pkg\/time\/\"><span style=\"font-weight: 400\">\uace8\ub791 \ud0c0\uc784 \ud328\ud0a4\uc9c0.<\/span><\/a><\/p>\n<p><span style=\"font-weight: 400\"><em>YearDay<\/em> \ub294 \uc724\ub144\uc774 \uc544\ub2cc \uacbd\uc6b0 1~365, \uc724\ub144\uc778 \uacbd\uc6b0 1~366 \ubc94\uc704\uc5d0\uc11c \uc2dc\uac04\uc73c\ub85c \uc9c0\uc815\ub41c \uc5f0\ub3c4\uc758 \ub0a0\uc9dc\ub97c \ubc18\ud658\ud569\ub2c8\ub2e4.<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"doy\") as D from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": 360\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">\uc694\uc77c_\uc694\uc77c(\ub2e4\uc6b0)<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u274c<\/span><\/td>\n<td><span style=\"font-weight: 400\">\u2705<\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc694\uc77c_\uc694\uc77c \ub610\ub294 \ub2e4\uc6b0 = <em>\ud3c9\uc77c<\/em> \ud568\uc218\ub97c \ud638\ucd9c\ud558\uba74 \uc8fc\uc5b4\uc9c4 \uc2dc\uac04 \ub3d9\uc548\uc758 \uc694\uc77c\uc744 \ubc18\ud658\ud569\ub2c8\ub2e4. \ucc38\uc870 <\/span><a href=\"https:\/\/golang.org\/pkg\/time\/\"><span style=\"font-weight: 400\">\uace8\ub791 \ud0c0\uc784 \ud328\ud0a4\uc9c0<\/span><\/a><span style=\"font-weight: 400\">.<\/span><\/p>\n<pre class=\"lang:default decode:true\">select \r\nDATE_PART_STR(date_purchased,\r\n\"dow\") as D from bucket1;\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"D\": 4\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<p>&nbsp;<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2>\ud45c\uc900 \uc2dc\uac04\ub300 \uace0\ub824 \uc0ac\ud56d<\/h2>\n<p><span style=\"font-weight: 400\">N1QL\uc758 \uacbd\uc6b0 \ub0a0\uc9dc \uc2dc\uac04 \ud615\uc2dd \ub0b4\uc785\ub2c8\ub2e4, <em>\uc2dc\uac04\ub300_\uc9c0\uc5ed<\/em> \uadf8\ub9ac\uace0 <em>TIMEZONE_ABBR<\/em> \ub294 \uc9c0\uc6d0\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc <a href=\"https:\/\/docs.couchbase.com\/server\/current\/n1ql\/n1ql-language-reference\/datefun.html#manipulating-components\">\uc2dc\uac04\ub300\ubcc4 N1QL \uae30\ub2a5.<\/a><\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc704\uc5d0\uc11c \uc0b4\ud3b4\ubcf8 \ubc14\uc640 \uac19\uc774 <em>\ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \ub0a0\uc9dc \ub0b4\uc5d0\uc11c \uc9c0\uc6d0\ub418\ub294 \ucd94\uac00 \ud544\ub4dc\uac00 \uc788\uc2b5\ub2c8\ub2e4. \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <em>ISO_YEAR<\/em>, <em>ISO_WEEK<\/em>, <em>DAY_OF_YEAR <\/em>(DOY), <em>DAY_OF_WEEK <\/em>(DOW) \ubc0f <em>\uc2dc\uac04\ub300<\/em> \ub294 UTC\ub85c\ubd80\ud130\uc758 \uc624\ud504\uc14b\uc785\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\ud45c\uc900 \uc2dc\uac04\ub300 \ud45c\uc2dc\uae30\uac00 \uc5c6\ub294 \uacbd\uc6b0 \ud604\uc7ac \ud604\uc9c0 \ud45c\uc900 \uc2dc\uac04\ub300\ub294 Couchbase \uc11c\ubc84\uac00 \uc704\uce58\ud55c \uacf3\uc5d0\uc11c \uac00\uc838\uc635\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc880 \ub354 \uc790\uc138\ud788 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. <em>\uc2dc\uac04\ub300<\/em> N1QL\uacfc Oracle\uc744 \ube44\uad50\ud569\ub2c8\ub2e4. \uadf8\ub9ac\uace0 <em>\ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> <em>\uc2dc\uac04\ub300 \ud3ec\ud568<\/em> \uadf8\ub9ac\uace0 <em>\ud604\uc9c0 \uc2dc\uac04\ub300\uac00 \ud3ec\ud568\ub41c \ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \uc624\ub77c\ud074\uc758 \ub370\uc774\ud130 \uc720\ud615\uc740 <em>\ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \ub370\uc774\ud130 \uc720\ud615\uc785\ub2c8\ub2e4. \uc804\uc790\ub294 UTC \ub610\ub294 \uc2dc\uac04\ub300 \uc9c0\uc5ed \uc774\ub984\uc5d0 \ub300\ud55c \uc0c1\ub300\uc801\uc778 \uc2dc\uac04\uc778 \uc2dc\uac04\ub300 \uc624\ud504\uc14b\uc778 \uc2dc\uac04\ub300 \uc815\ubcf4\ub97c \uac12\uc5d0 \ud3ec\ud568\ud558\uace0, \ud6c4\uc790\ub294 \ud604\uc7ac \uc138\uc158 \uc2dc\uac04\ub300\ub97c \ud3ec\ud568\ud569\ub2c8\ub2e4. <em>\ud604\uc9c0 \uc2dc\uac04\ub300\uac00 \ud3ec\ud568\ub41c \ud0c0\uc784\uc2a4\ud0ec\ud504<\/em> \ub294 \ub0b4\ubd80\uc801\uc73c\ub85c \ud45c\uc900 \uc2dc\uac04\ub300 \uc815\ubcf4\ub97c \uc800\uc7a5\ud558\uc9c0 \uc54a\uc9c0\ub9cc, SQL \ucd9c\ub825\uc5d0\uc11c \ud604\uc9c0 \ud45c\uc900 \uc2dc\uac04\ub300 \uc815\ubcf4\ub97c \ubcfc \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em>TZH:TZM<\/em> \ub610\ub294 <em>TZR TZD<\/em> \ud615\uc2dd \uc694\uc18c\uac00 \uc9c0\uc815\ub429\ub2c8\ub2e4. Oracle \uc124\uba85\uc11c\ub97c \ucc38\uc870\ud558\uc2ed\uc2dc\uc624: <a href=\"https:\/\/docs.oracle.com\/cd\/B19306_01\/server.102\/b14225\/ch4datetime.htm#i1005943\">\ub0a0\uc9dc \uc2dc\uac04 \ub370\uc774\ud130 \uc720\ud615 \ubc0f \uc2dc\uac04\ub300 \uc9c0\uc6d0 <\/a><\/span><span style=\"font-weight: 400\">\uc5d0\uc11c \uc790\uc138\ud55c \ub0b4\uc6a9\uc744 \ud655\uc778\ud558\uc138\uc694.<\/span><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-weight: 400\">Oracle:\u00a0\u00a0<\/span><em><span style=\"font-weight: 400\">\ud0c0\uc784\uc2a4\ud0ec\ud504 '2017-01-31 03:49:30.612 -08:00'<\/span><\/em><\/p>\n<p style=\"padding-left: 40px\"><span style=\"font-weight: 400\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4:\u00a0<\/span><em><span style=\"font-weight: 400\">\u201c2017-01-31T03:49:30.612-08:00\u201d<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Oracle\uc758 \uacbd\uc6b0 \ube44\uad50 \ub300\uc0c1\uc778 \ub450 \ub0a0\uc9dc\uac00 UTC\ub85c \ub3d9\uc77c\ud55c \uac12\uc744 \ub098\ud0c0\ub0b4\uba74 \ub450 \ub0a0\uc9dc\ub294 \ub3d9\uc77c\ud569\ub2c8\ub2e4:<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">\ud0c0\uc784\uc2a4\ud0ec\ud504 '2017-01-15 8:00:00 -8:00' == \ud0c0\uc784\uc2a4\ud0ec\ud504 '2017-01-15 10:00:00 -6:00'<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">N1QL\uc5d0\uc11c\ub294 \uc804\uccb4 \ub0a0\uc9dc \uac12\uc744 \ube44\uad50\ud558\ub824\uba74 \ubc00\ub9ac\ucd08\ub85c \ubcc0\ud658\ud574\uc57c \ud569\ub2c8\ub2e4.<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">STR_TO_MILLIS(\u201c2017-01-31T05:49:30.612-06:00\u201d) == STR_TO_MILLIS(\u201c2017-01-31T03:49:30.612-08:00\u201d) \u00a0<\/span><\/em><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">\uac00\uce58: 1485863370612<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">\uc624\ub77c\ud074\uc5d0\uc11c\ub294 \uc774 \uc624\ud504\uc14b\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \ub300\uccb4\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <em>\uc2dc\uac04\ub300 \uc9c0\uc5ed<\/em> (TZR) \ubc0f \uc57d\uc5b4. \uc9c0\uc5ed \uac12\uc774 \ubaa8\ud638\ud55c \uacbd\uc6b0(\ubbf8\uad6d\uc774 \uc11c\uba38\ud0c0\uc784\uc73c\ub85c \uc804\ud658\ud558\ub294 \uacbd\uc6b0)\uc5d0\ub294 \uc57d\uc5b4(TZD)\uac00 \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uadf8\ub7ec\ub098 N1QL\uc5d0\uc11c \ub0a0\uc9dc\uc758 \ud45c\uc900 \uc2dc\uac04\ub300 \uad6c\uc131 \uc694\uc18c\ub294 \ud56d\uc0c1 UTC \uc624\ud504\uc14b\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">\uc608\ub97c \ub4e4\uc5b4<\/span><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">\ud0c0\uc784\uc2a4\ud0ec\ud504 '2017-01-15 8:00:00 -8:00' <\/span><\/em><\/p>\n<p><em><span style=\"font-weight: 400\">\uac00 \ub420 \uc218\ub3c4 \uc788\uc2b5\ub2c8\ub2e4: <\/span><\/em><\/p>\n<p style=\"padding-left: 40px\"><em><span style=\"font-weight: 400\">\ud0c0\uc784\uc2a4\ud0ec\ud504 '2017-01-15 8:00:00 \ubbf8\uad6d\/\ud0dc\ud3c9\uc591 \ud45c\uc900\uc2dc'<\/span><\/em><\/p>\n<p><span style=\"font-weight: 400\">Oracle\uc740 \uac04\uaca9 \ub370\uc774\ud130 \uc720\ud615\ub3c4 \uc9c0\uc6d0\ud569\ub2c8\ub2e4. <em>\ub144\uc5d0\uc11c \uc6d4\uae4c\uc9c0\uc758 \uac04\uaca9<\/em> \uadf8\ub9ac\uace0 <em>\ud558\ub8e8 \uac04\uaca9\uc5d0\uc11c \ucd08 \uac04\uaca9<\/em>. \uc774\ub4e4\uc740 \uc2dc\uac04 \uae30\uac04\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4. \uc804\uc790\ub294 \uc5f0\ub3c4 \ubc0f \uc6d4 \ud544\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uae30\uac04\uc744 \uc800\uc7a5\ud558\uace0 \ud6c4\uc790\ub294 \uc77c, \uc2dc\uac04, \ubd84 \ubc0f \ucd08 \ud544\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \uae30\uac04\uc744 \uc800\uc7a5\ud569\ub2c8\ub2e4. N1QL\uc744 \uc0ac\uc6a9\ud558\uba74 \ub0a0\uc9dc \uc2dc\uac04 \ud568\uc218\uc640 '\ubd80\ubd84' \uad6c\uc131 \uc694\uc18c\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac04\uaca9\uc744 \uc27d\uac8c \uacc4\uc0b0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">Oracle\uc5d0 \ub0a0\uc9dc \ub610\ub294 \uc2dc\uac04 \ub370\uc774\ud130\ub97c \uc0bd\uc785\ud558\ub294 \ubc29\ubc95\uc5d0\ub294 \uc5ec\ub7ec \uac00\uc9c0\uac00 \uc788\uc2b5\ub2c8\ub2e4. \uc0ac\uc6a9\uc790\ub294 NLS \ud615\uc2dd \uac12\uc744 \uae30\ubc18\uc73c\ub85c \ud615\uc2dd\uc774 \uc9c0\uc815\ub41c \ubb38\uc790\uc5f4\uc744 \uc0bd\uc785\ud558\uac70\ub098, \uba85\uc2dc\uc801\uc73c\ub85c \ubcc0\ud658\ub41c \ub9ac\ud130\ub7f4\uc744 \uc0ac\uc6a9\ud558\uc5ec <em>TO_DATE<\/em> \/ <em>TO_TIMESTAMP<\/em> \ub610\ub294 <em>to_timestamp_tz<\/em> \ud568\uc218 \ub610\ub294 \uc554\uc2dc\uc801 \ubcc0\ud658\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"font-weight: 400\">N1QL\uc5d0\uc11c\ub294 \ubaa8\ub4e0 \ub0a0\uc9dc\uac00 \uc704\uc5d0 \uc9c0\uc815\ub41c \ud615\uc2dd\uc758 \ubb38\uc790\uc5f4 \ub610\ub294 \ubc00\ub9ac\ucd08 \ub2e8\uc704\uc758 \uc720\ub2c9\uc2a4 \ud0c0\uc784\uc2a4\ud0ec\ud504\ub97c \ub098\ud0c0\ub0b4\ub294 \uc22b\uc790\ub85c \ubb38\uc11c\uc5d0 \ucd94\uac00\ub429\ub2c8\ub2e4. \ud568\uc218\uac00 \uc0ac\uc6a9\uc790\uc5d0\uac8c \ud544\uc694\ud55c \ubaa8\ub4e0 \uc5f0\uc0b0\uc744 \uc218\ud589\ud558\ubbc0\ub85c \ub0a0\uc9dc\ub97c \ub9e4\uc6b0 \uc27d\uace0 \uc720\uc5f0\ud558\uac8c \ucc98\ub9ac\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ud558\uc9c0\ub9cc \ud55c \uac00\uc9c0 \ub2e8\uc810\uc740 \ub0a0\uc9dc\uac00 \ub0a0\uc9dc \ud615\uc2dd \ud45c\uc758 \ud615\uc2dd \uc911 \ud558\ub098\uc640 \uc815\ud655\ud788 \uc77c\uce58\ud574\uc57c \ud55c\ub2e4\ub294 \uac83\uc785\ub2c8\ub2e4. \ub530\ub77c\uc11c \uc0ac\uc6a9\uc790\ub294 \uc0ac\uc6a9 \uac00\ub2a5\ud55c \ud615\uc2dd\uc758 \ud558\uc704 \uc9d1\ud569\ub9cc \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc81c\ud55c\ub429\ub2c8\ub2e4. <\/span><\/p>\n<p><span style=\"font-weight: 400\">N1QL\uc758 \uc774 \uc81c\ud55c\uc5d0 \ub300\ud55c \ud55c \uac00\uc9c0 \ud574\uacb0 \ubc29\ubc95\uc740 \ubb38\uc790\uc5f4 \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \uc785\ub825 \ub0a0\uc9dc\ub97c \uc6d0\ud558\ub294 \ud615\uc2dd\uc5d0 \ub9de\uac8c \ubcc0\uacbd\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4<\/span><\/p>\n<p><span style=\"font-weight: 400\">2016-09-23T18:48:11.000+00:00\uc744 \"YYYY\/MM\/DD\"\ub85c \ubcc0\ud658\ud558\uae30<\/span><\/p>\n<pre class=\"lang:default decode:true\">SELECT \u00a0to_string(date_part_str(\"2016-09-23T18:48:11.000+00:00\", \"year\" )) || \"\/\" || to_string(date_part_str(\"2016-09-23T18:48:11.000+00:00\", \"month\" )) || \"\/\" || to_string(date_part_str(\"2016-09-23T18:48:11.000+00:00\", \"day\" ));\r\n\r\n\"results\": [\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0{\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\"$1\": \"2016\/9\/23\"\r\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0}\r\n\u00a0\u00a0\u00a0]<\/pre>\n<p><span style=\"font-weight: 400\">\ubcf4\uc2dc\ub2e4\uc2dc\ud53c, N1QL\uc740 \ub0a0\uc9dc \ubc0f \ud0c0\uc784\uc2a4\ud0ec\ud504\ub97c \ubb38\uc790\uc5f4\uc774\ub098 \uc22b\uc790\ub85c \ud45c\ud604\ud558\uc5ec \uc624\ub77c\ud074 \ub0a0\uc9dc-\ud0c0\uc784\uc2a4\ud0ec\ud504 \ud615\uc2dd\uacfc \ube44\uad50\ud588\uc744 \ub54c \uc870\uc791\uc744 \ub2e8\uc21c\ud654\ud569\ub2c8\ub2e4. \uadf8\ub7ec\ub098 \uc774\ub294 \uc0ac\uc6a9\uc790\uac00 \uc9c0\uc815\ub41c \ub0a0\uc9dc \uc2dc\uac04 \ud615\uc2dd\ub9cc \uc0ac\uc6a9\ud558\ub3c4\ub85d \uc81c\ud55c\ub418\uace0 \uc774\ub7ec\ud55c \ud615\uc2dd\uc744 \uc790\uc720\ub86d\uac8c \uc870\uc791\ud560 \uc218 \uc5c6\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud558\uba70, \uc624\ub77c\ud074\uc740 \ud615\uc2dd \ub9e4\uac1c\ubcc0\uc218\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub9e4\uc6b0 \uc27d\uac8c \uc774\ub7ec\ud55c \ud615\uc2dd\uc744 \uc870\uc791\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/span><\/p>\n<p><span style=\"color: #343e47;font-family: Lato, 'Helvetica Neue', Helvetica, Arial, sans-serif;font-size: 50px\">\uacc4\uc18d \ud559\uc2b5\ud558\uae30<\/span><\/p>\n<p>Couchbase SQL++ \uc5b8\uc5b4\ub85c JSON \ubb38\uc11c\ub97c \ucffc\ub9ac\ud574 \ubcfc \uc900\ube44\uac00 \ub418\uc168\ub098\uc694?<\/p>\n<ul>\n<li style=\"list-style-type: none\">\n<ul>\n<li>\ubb34\ub8cc \uc2dc\uc791 <a href=\"https:\/\/cloud.couchbase.com\">\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uce74\ud3a0\ub77c \ud3c9\uac00\ud310<\/a> \ub97c \ud074\ub9ad\ud558\uace0 \uc5bc\ub9c8\ub098 \uc26c\uc6b4\uc9c0 \ud655\uc778\ud574 \ubcf4\uc138\uc694.<\/li>\n<li>\ucc38\uc870 <a href=\"https:\/\/www.youtube.com\/embed\/zoZW0tM6hwU\">\uc624\ub77c\ud074\uc5d0\uc11c \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158<\/a> \uc804\ub7b5 \ube44\ub514\uc624<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><iframe loading=\"lazy\" title=\"\uc624\ub77c\ud074\uc5d0\uc11c \uce74\uc6b0\uce58\ubca0\uc774\uc2a4\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158 - CBConnect21\" width=\"900\" height=\"506\" src=\"https:\/\/www.youtube.com\/embed\/zoZW0tM6hwU?feature=oembed&#038;enablejsapi=1&#038;origin=https:\/\/www.couchbase.com\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>","protected":false},"excerpt":{"rendered":"<p>Date and Time functions and formats can vary for different databases. In this article, we shall compare Couchbase ISO-based Date-Time functions with Oracle Date format. Date formats vary between relational and NoSQL database due to the nature of NoSQL JSON [&hellip;]<\/p>","protected":false},"author":82066,"featured_media":14419,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[1815,1816,1819,1812],"tags":[9405,1592,1385],"ppma_author":[9657],"class_list":["post-4045","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-best-practices-and-tutorials","category-couchbase-server","category-data-modeling","category-n1ql-query","tag-database-migration","tag-oracle","tag-rdbms"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v25.8 (Yoast SEO v25.8) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Oracle Date-Time &amp; Timestamp Format Compared to Couchbase<\/title>\n<meta name=\"description\" content=\"Explore the differences between Oracle&#039;s and Couchbase&#039;s date-time formats and their handling of timestamps here. We offer side-by-side examples.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.couchbase.com\/blog\/ko\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Date Format: N1QL and Support for Date-Time Functions\" \/>\n<meta property=\"og:description\" content=\"Explore the differences between Oracle&#039;s and Couchbase&#039;s date-time formats and their handling of timestamps here. We offer side-by-side examples.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.couchbase.com\/blog\/ko\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/\" \/>\n<meta property=\"og:site_name\" content=\"The Couchbase Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-09-23T04:36:20+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-14T06:43:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Couchbase Product Marketing\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Couchbase Product Marketing\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/\"},\"author\":{\"name\":\"Couchbase Product Marketing\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/befa2a9de827aed2f8354f939cd6598e\"},\"headline\":\"Oracle Date Format: N1QL and Support for Date-Time Functions\",\"datePublished\":\"2017-09-23T04:36:20+00:00\",\"dateModified\":\"2025-06-14T06:43:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/\"},\"wordCount\":2325,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png\",\"keywords\":[\"database migration\",\"oracle\",\"RDBMS\"],\"articleSection\":[\"Best Practices and Tutorials\",\"Couchbase Server\",\"Data Modeling\",\"SQL++ \/ N1QL Query\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/\",\"name\":\"Oracle Date-Time & Timestamp Format Compared to Couchbase\",\"isPartOf\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png\",\"datePublished\":\"2017-09-23T04:36:20+00:00\",\"dateModified\":\"2025-06-14T06:43:22+00:00\",\"description\":\"Explore the differences between Oracle's and Couchbase's date-time formats and their handling of timestamps here. We offer side-by-side examples.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#primaryimage\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.couchbase.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Date Format: N1QL and Support for Date-Time Functions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#website\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"name\":\"The Couchbase Blog\",\"description\":\"Couchbase, the NoSQL Database\",\"publisher\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#organization\",\"name\":\"The Couchbase Blog\",\"url\":\"https:\/\/www.couchbase.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"contentUrl\":\"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png\",\"width\":218,\"height\":34,\"caption\":\"The Couchbase Blog\"},\"image\":{\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/befa2a9de827aed2f8354f939cd6598e\",\"name\":\"Couchbase Product Marketing\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/5112ed57023bd2807ae7086c2fe68752\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4760a19fc4ed6b8b830ba98f0869ed0d8ee6729e2593881e1a68032b9c281d5d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4760a19fc4ed6b8b830ba98f0869ed0d8ee6729e2593881e1a68032b9c281d5d?s=96&d=mm&r=g\",\"caption\":\"Couchbase Product Marketing\"},\"url\":\"https:\/\/www.couchbase.com\/blog\/ko\/author\/couchbase-pmm\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Date-Time & Timestamp Format Compared to Couchbase","description":"Explore the differences between Oracle's and Couchbase's date-time formats and their handling of timestamps here. We offer side-by-side examples.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.couchbase.com\/blog\/ko\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/","og_locale":"ko_KR","og_type":"article","og_title":"Oracle Date Format: N1QL and Support for Date-Time Functions","og_description":"Explore the differences between Oracle's and Couchbase's date-time formats and their handling of timestamps here. We offer side-by-side examples.","og_url":"https:\/\/www.couchbase.com\/blog\/ko\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/","og_site_name":"The Couchbase Blog","article_published_time":"2017-09-23T04:36:20+00:00","article_modified_time":"2025-06-14T06:43:22+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png","type":"image\/png"}],"author":"Couchbase Product Marketing","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Couchbase Product Marketing","Est. reading time":"10\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#article","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/"},"author":{"name":"Couchbase Product Marketing","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/befa2a9de827aed2f8354f939cd6598e"},"headline":"Oracle Date Format: N1QL and Support for Date-Time Functions","datePublished":"2017-09-23T04:36:20+00:00","dateModified":"2025-06-14T06:43:22+00:00","mainEntityOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/"},"wordCount":2325,"commentCount":0,"publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png","keywords":["database migration","oracle","RDBMS"],"articleSection":["Best Practices and Tutorials","Couchbase Server","Data Modeling","SQL++ \/ N1QL Query"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/","url":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/","name":"Oracle Date-Time & Timestamp Format Compared to Couchbase","isPartOf":{"@id":"https:\/\/www.couchbase.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#primaryimage"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png","datePublished":"2017-09-23T04:36:20+00:00","dateModified":"2025-06-14T06:43:22+00:00","description":"Explore the differences between Oracle's and Couchbase's date-time formats and their handling of timestamps here. We offer side-by-side examples.","breadcrumb":{"@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#primaryimage","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2017\/09\/oracle-date-time-compare-couchbase.png","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/www.couchbase.com\/blog\/dates-timestamps-timezones-comparative-study-oracle-n1ql-support-date-time-feature-part-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.couchbase.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Date Format: N1QL and Support for Date-Time Functions"}]},{"@type":"WebSite","@id":"https:\/\/www.couchbase.com\/blog\/#website","url":"https:\/\/www.couchbase.com\/blog\/","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","description":"NoSQL \ub370\uc774\ud130\ubca0\uc774\uc2a4, Couchbase","publisher":{"@id":"https:\/\/www.couchbase.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.couchbase.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.couchbase.com\/blog\/#organization","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \ube14\ub85c\uadf8","url":"https:\/\/www.couchbase.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","contentUrl":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/2023\/04\/admin-logo.png","width":218,"height":34,"caption":"The Couchbase Blog"},"image":{"@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/befa2a9de827aed2f8354f939cd6598e","name":"\uce74\uc6b0\uce58\ubca0\uc774\uc2a4 \uc81c\ud488 \ub9c8\ucf00\ud305","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.couchbase.com\/blog\/#\/schema\/person\/image\/5112ed57023bd2807ae7086c2fe68752","url":"https:\/\/secure.gravatar.com\/avatar\/4760a19fc4ed6b8b830ba98f0869ed0d8ee6729e2593881e1a68032b9c281d5d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4760a19fc4ed6b8b830ba98f0869ed0d8ee6729e2593881e1a68032b9c281d5d?s=96&d=mm&r=g","caption":"Couchbase Product Marketing"},"url":"https:\/\/www.couchbase.com\/blog\/ko\/author\/couchbase-pmm\/"}]}},"authors":[{"term_id":9657,"user_id":82066,"is_guest":0,"slug":"couchbase-pmm","display_name":"Couchbase Product Marketing","avatar_url":{"url":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/06\/image_2022-06-17_105452255.png","url2x":"https:\/\/www.couchbase.com\/blog\/wp-content\/uploads\/sites\/1\/2022\/06\/image_2022-06-17_105452255.png"},"author_category":"","last_name":"","first_name":"Couchbase Product Marketing","job_title":"","user_url":"","description":""}],"_links":{"self":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/users\/82066"}],"replies":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/comments?post=4045"}],"version-history":[{"count":0,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/posts\/4045\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media\/14419"}],"wp:attachment":[{"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/media?parent=4045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/categories?post=4045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/tags?post=4045"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.couchbase.com\/blog\/ko\/wp-json\/wp\/v2\/ppma_author?post=4045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}