{"id":2953,"date":"2020-07-02T14:56:42","date_gmt":"2020-07-02T05:56:42","guid":{"rendered":"http:\/\/autooffice.co.kr\/?p=2953"},"modified":"2025-09-15T18:56:08","modified_gmt":"2025-09-15T09:56:08","slug":"%ea%b5%ac%ea%b8%80-query%eb%a1%9c-%eb%b6%88%eb%9f%ac%ec%98%a8-%eb%82%a0%ec%a7%9c%ec%9d%98-%ed%8f%ac%eb%a7%b7-%eb%b3%80%ea%b2%bd%ed%95%98%ea%b8%b0","status":"publish","type":"post","link":"https:\/\/www.autooffice.co.kr\/en\/blog\/2020\/07\/02\/%ea%b5%ac%ea%b8%80-query%eb%a1%9c-%eb%b6%88%eb%9f%ac%ec%98%a8-%eb%82%a0%ec%a7%9c%ec%9d%98-%ed%8f%ac%eb%a7%b7-%eb%b3%80%ea%b2%bd%ed%95%98%ea%b8%b0\/","title":{"rendered":"\uad6c\uae00\uc2dc\ud2b8 QUERY: QUERY\ub85c \ubd88\ub7ec\uc628 \ub0a0\uc9dc\uc758 \ud3ec\ub9f7 \ubcc0\uacbd\ud558\uae30"},"content":{"rendered":"\n

\uc55e \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc774\uc5b4\uc9d1\ub2c8\ub2e4. <\/p>\n\n\n\n

\uad6c\uae00 QUERY\ub85c \ubd88\ub7ec\uc624\ub294 \uc5f4\uc758 \uc55e\ubd80\ubd84 10\uc790\ub9ac\ub9cc \ubd88\ub7ec\uc624\ub294 \ubc29\ubc95<\/a><\/p>\n\n\n\n

\n\n\n\n

\uad6c\uae00 \ucffc\ub9ac\ub85c \ubd88\ub7ec\uc628 \ub0a0\uc9dc\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \ub0a0\uc9dc\ub85c \uc778\uc2dd\ub418\ub294\uc9c0 \uccb4\ud06c\ud574\ubcf4\uae30 \uc704\ud574 1\uc744 \ub354\ud574\ubcf4\uba74, \uc815\uc0c1\uc784\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc774\ub77c\uba74 #VALUE \uac12\uc774 \ud45c\uc2dc\ub420 \uac83\uc785\ub2c8\ub2e4. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\uadf8\ub7f0\ub370, \uc140 \ud615\uc2dd\uc744 \uc544\ubb34\ub9ac \ubc14\uafb8\uc5b4\ubcf4\uc544\ub3c4 \ucffc\ub9ac\ub85c \ubd88\ub7ec\uc628 \ub0a0\uc9dc\ub294 \uafc8\uca4d\ud558\uc9c0\ub97c \uc54a\uc2b5\ub2c8\ub2e4. +1\uc744 \ud55c \uc140\uc740 \ud615\uc2dd\uc744 \uc801\uc6a9\ud558\ub294 \ub300\ub85c \uc798 \ubc14\ub00c\ub294\ub370 \ub9d0\uc774\uc8e0. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\ucffc\ub9ac\uc758 FORMAT \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud574\uc11c \ud3ec\ub9f7\uc744 \ubd80\uc5ec\ud558\ub824\uace0 \ud574\ub3c4 \uc544\ubb34\ub7f0 \uc18c\uc6a9\uc774 \uc5c6\uc2b5\ub2c8\ub2e4.<\/p>\n\n\n\n

\uc774 \ubb38\uc81c\ub97c \ud574\uacb0\ud558\uae30 \uc704\ud574\uc11c\ub294 \ucffc\ub9ac\ub97c \uc801\uc6a9\ud558\uae30 \uc804\uc5d0 \ubc94\uc704\ub97c \uc218\uc815\ud560 \ud544\uc694\uac00 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n

\uc55e\uc5d0 10\uc790\ub9ac\ub97c \ubd88\ub7ec\uc624\ub294 \ud568\uc218\ub85c LEFT\ub97c \uc0ac\uc6a9\ud588\ub294\ub370, \uc774\uc81c LEFT\ub85c \ubd88\ub7ec\uc628 \uac12\uc744 \uc22b\uc790\ub85c \ubc14\uafb8\uc5b4\uc8fc\ub294 \uac83\uc73c\ub85c \ud574\uacb0\uc774 \ub429\ub2c8\ub2e4. ARRAYFORMULA\ub294 DATEVALUE \ub97c \ud55c \uac12\uc5d0 \ub354\ud574\uc90d\ub2c8\ub2e4. <\/p>\n\n\n\n

=QUERY({ArrayFormula(datevalue(left(A1:A15,10))),B1:B15},\"SELECT * format Col1 'yyyy-mm-dd (ddd)'\",0)<\/pre>\n\n\n\n
 LEFT(A1,10)\uc744 \uc801\uc6a9\ud558\uba74 \ub0a0\uc9dc \ubb38\uc790\uc5f4\uc778 2020-01-02\ub97c \uac00\uc838\uc624\uace0, \uc774\uc5d0 DATEVALUE(2020-01-02)\ub97c \uc801\uc6a9\ud558\uba74 \uc22b\uc790 43832\ub85c \ub0a0\uc9dc\uac00 \ud45c\uc2dc\ub429\ub2c8\ub2e4. <\/strong><\/p>\n\n\n\n
\uc774\uc81c \uc22b\uc790 \ud615\uc2dd\uc73c\ub85c \ubc14\ub00c\uc5c8\uae30 \ub54c\ubb38\uc5d0 \ucffc\ub9ac\uc758 FORMAT \ud568\uc218\ub97c \uc790\uc720\uc790\uc7ac\ub85c \uc801\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\uc801\uc6a9\ud560 \uc218 \uc788\ub294 \ub0a0\uc9dc \ud615\uc2dd\uc740 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n
\ub0a0\uc9dc \ucf54\ub4dc<\/td>\uc124\uba85<\/td>\uc608<\/td><\/tr>
d<\/td>1-31 (\uc77c)<\/td>7<\/td><\/tr>
dd<\/td>01-09 (\uc77c)<\/td>07<\/td><\/tr>
ddd<\/td>\uc6d4-\uc77c<\/td>Wed, \uc218<\/td><\/tr>
dddd<\/td>\uc6d4\uc694\uc77c-\uc77c\uc694\uc77c<\/td>Wednesday, \uc218\uc694\uc77c<\/td><\/tr>
m<\/td>1-12 (\uc6d4)<\/td>8<\/td><\/tr>
mm<\/td>01-12 (\uc6d4)<\/td>08<\/td><\/tr>
mmm<\/td>1\uc6d4-12\uc6d4<\/td>Aug, 8\uc6d4<\/td><\/tr>
mmmm<\/td>\uc601\uc5b4\uc77c\ub54c \ud480 \ub124\uc784<\/td>August<\/td><\/tr>
mmmmm<\/td>\ud480\ub124\uc784\uc758 \uac00\uc7a5 \uccab \uae00\uc790<\/td>A<\/td><\/tr>
y
or
yy<\/td>		2\uae00\uc790 \ud574<\/td>20<\/td><\/tr>
yyy
or
yyyy<\/td>		4\uae00\uc790 \ud574<\/td>2020<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

<\/p>\n\n\n\n
\n\n\n\n

<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\uc5c5\ubb34 \ud6a8\uc728\uc131 200% \uc62c\ub9ac\uae30, with autooffice<\/h2>\n\n\n\n
\ud504\ub85c\uc81d\ud2b8 \uac1c\ubc1c \ubb38\uc758\ub294 \uad6c\uae00\ud3fc\uc744 \uc774\uc6a9\ud574\uc8fc\uc138\uc694!<\/h2>\n\n\n\n
<\/p>\n\n\n\n
\uc624\ud1a0\uc624\ud53c\uc2a4 \ud504\ub85c\uc81d\ud2b8 \ubb38\uc758<\/a><\/p>\n\n\n\n

<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc55e \ud3ec\uc2a4\ud2b8\uc5d0\uc11c \uc774\uc5b4\uc9d1\ub2c8\ub2e4. \uad6c\uae00 QUERY\ub85c \ubd88\ub7ec\uc624\ub294 \uc5f4\uc758 \uc55e\ubd80\ubd84 10\uc790\ub9ac\ub9cc \ubd88\ub7ec\uc624\ub294 \ubc29\ubc95 \uad6c\uae00 \ucffc\ub9ac\ub85c \ubd88\ub7ec\uc628 \ub0a0\uc9dc\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \ub0a0\uc9dc\ub85c \uc778\uc2dd\ub418\ub294\uc9c0 \uccb4\ud06c\ud574\ubcf4\uae30 \uc704\ud574 1\uc744 \ub354\ud574\ubcf4\uba74, \uc815\uc0c1\uc784\uc744 \uc54c \uc218 \uc788\uc2b5\ub2c8\ub2e4. \ub9cc\uc57d \ud14d\uc2a4\ud2b8 \ud615\uc2dd\uc774\ub77c\uba74 #VALUE \uac12\uc774 \ud45c\uc2dc\ub420 \uac83\uc785\ub2c8\ub2e4. \uadf8\ub7f0\ub370, \uc140 \ud615\uc2dd\uc744 \uc544\ubb34\ub9ac \ubc14\uafb8\uc5b4\ubcf4\uc544\ub3c4 \ucffc\ub9ac\ub85c \ubd88\ub7ec\uc628 \ub0a0\uc9dc\ub294 \uafc8\uca4d\ud558\uc9c0\ub97c \uc54a\uc2b5\ub2c8\ub2e4. +1\uc744 \ud55c \uc140\uc740 \ud615\uc2dd\uc744 \uc801\uc6a9\ud558\ub294 \ub300\ub85c \uc798 \ubc14\ub00c\ub294\ub370 \ub9d0\uc774\uc8e0. \ucffc\ub9ac\uc758 FORMAT \uae30\ub2a5\uc744…<\/p>\n","protected":false},"author":1,"featured_media":2960,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[5],"tags":[23,15,24],"class_list":["post-2953","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-spreadsheet","tag-datevalue","tag-query","tag-24"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"en","enabled_languages":["ko","en"],"languages":{"ko":{"title":true,"content":true,"excerpt":false},"en":{"title":false,"content":false,"excerpt":false}}},"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/2953","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/comments?post=2953"}],"version-history":[{"count":2,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/2953\/revisions"}],"predecessor-version":[{"id":17242,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/posts\/2953\/revisions\/17242"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media\/2960"}],"wp:attachment":[{"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/media?parent=2953"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/categories?post=2953"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.autooffice.co.kr\/en\/wp-json\/wp\/v2\/tags?post=2953"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}