{"id":175,"date":"2019-07-10T15:01:39","date_gmt":"2019-07-10T06:01:39","guid":{"rendered":"http:\/\/poteto.co.kr\/?p=175"},"modified":"2019-07-10T15:01:39","modified_gmt":"2019-07-10T06:01:39","slug":"mariadbmysql-%eb%82%a0%ec%a7%9c%ec%99%80-%ec%8b%9c%ea%b0%84-%ed%95%a8%ec%88%98-%ed%8e%8c","status":"publish","type":"post","link":"http:\/\/poteto.co.kr\/wordpress\/?p=175","title":{"rendered":"mariadb(mysql) \ub0a0\uc9dc\uc640 \uc2dc\uac04 \ud568\uc218 – \ud38c"},"content":{"rendered":"

DATE \uac12\uc744 \uae30\ub300\ud558\ub294 \ud568\uc218\ub4e4\uc740 \uc77c\ubc18\uc801\uc73c\ub85c DATETIME \uac12\uc744 \uc218\uc6a9\ud558\uace0, TIME \ubd80\ubd84\uc740 \ubb34\uc2dc\ud55c\ub2e4. TIME \uac12\uc744 \uae30\ub300\ud558\ub294 \ud568\uc218\ub4e4\uc740 \uc77c\ubc18\uc801\uc73c\ub85c DATETIME \uac12\uc744 \uc218\uc6a9\ud558\uace0, DATE \ubd80\ubd84\uc740 \ubb34\uc2dc\ud55c\ub2e4.<\/p>\n

\n
\n
\n
\n

\ud604\uc7ac \ub0a0\uc9dc\ub098 \uc2dc\uac04\uc744 \ubc18\ud658(return)\ud558\ub294 \ud568\uc218\ub4e4\uc740 \ucffc\ub9ac\uac00 \uc2e4\ud589\ub420 \ub54c \ub2e8 \ud55c\ubc88\ub9cc \uadf8 \uac12\uc744 \uad6c\ud55c\ub2e4. \uc774\uac83\uc740 \ud55c \ucffc\ub9ac \uc548\uc5d0 NOW()\uc640 \uac19\uc740 \ud568\uc218\uac00 \uc5ec\ub7ec\ubc88 \uc0ac\uc6a9\ub418\uc5c8\uc744 \uacbd\uc6b0\uc5d0\ub3c4 \ubaa8\ub450 \uac19\uc740 \uacb0\uacfc\uac12\uc744 \ucc38\uc870\ud55c\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud55c\ub2e4. \uc774 \uc6d0\uce59\uc740 CURDATE()<\/a>, CURTIME()<\/a>, UTC_DATE()<\/a>, UTC_TIME()<\/a>, UTC_TIMESTAMP()<\/a> \ub4f1\uc758 \ud568\uc218\uc5d0\ub3c4 \uc801\uc6a9\ub41c\ub2e4.<\/p>\n

MySQL 4.1.3 \ubc84\uc804\ubd80\ud130 \uc81c\uacf5\ub41c CURRENT_TIMESTAMP()<\/a>, CURRENT_TIME()<\/a>, CURRENT_DATE()<\/a>, FROM_UNIXTIME()<\/a> \ud568\uc218\ub4e4\uc740 \uc5f0\uacb0 \uc0c1\ud0dc\uc758 \ud604\uc7ac \uc2dc\uac04\ub300\uc5d0 \ud574\ub2f9\ub418\ub294 \ubc18\ud658\uac12\uc744 \uac16\ub294\ub2e4. \ub610\ud55c UNIX_TIMESTAMP()<\/a>\ub3c4 \uadf8 \uc778\uc790(argument)\uac00 \ud604\uc7ac \uc2dc\uac04\ub300\uc5d0 \ud574\ub2f9\ub418\ub294 DATETIME \uac12\uc774\ub77c\ub294 \uac83\uc744 \uac00\uc815\ud55c\ub2e4.<\/p>\n

\ub2e4\uc74c \ud568\uc218 \uc124\uba85\ub4e4\uc758 \ubc18\ud658\uac12 \ubc94\uc704\ub294 \uc644\uc804\ud55c \ub0a0\uc9dc\ub97c \uc694\uad6c\ud55c\ub2e4. \ub0a0\uc9dc\uac00 ‘0’\uc774\uac70\ub098 ‘2001-11-00’\ucc98\ub7fc \ubd88\uc644\uc804\ud558\ub2e4\uba74, DATE \ubd80\ubd84\uc744 \ucd94\ucd9c\ud558\ub294 \ud568\uc218\ub294 ‘0’\uc744 \ubc18\ud658\ud560 \uac83\uc774\ub2e4. \uc608\ub97c \ub4e4\uc5b4, DAYOFMONTH(‘2001-11-00’)\uc740 ‘0’\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n

ADDDATE(date<\/em>,INTERVAL expr type<\/em>) , ADDDATE(expr<\/em>,days<\/em>)<\/h2>\n

ADDDATE()\ub294 \ub450\ubc88\uc9f8 \uc778\uc790\uc5d0\uc11c INTERVAL\uacfc \ud568\uaed8 \uc0ac\uc6a9\ub418\uba74 DATE_ADD()<\/a>\uc758 \ubcc4\uce6d\uc774 \ub41c\ub2e4. \ub9c8\ucc2c\uac00\uc9c0\ub85c SUBDATE()<\/a>\ub294 DATE_SUB()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4. INTERVAL \uc778\uc790\uc5d0 \uad00\ud574\uc11c\ub294 DATE_ADD()<\/a> \uc124\uba85\uc744 \ucc38\uc870\ud558\ub77c.<\/p>\n

mysql> SELECT DATE_ADD('1998-01-02', INTERVAL 31 DAY);\r\n        -> '1998-02-02'\r\nmysql> SELECT ADDDATE('1998-01-02', INTERVAL 31 DAY);\r\n        -> '1998-02-02'\r\n<\/pre>\n
MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \ub450\ubc88\uc9f8 \ubb38\ubc95\uc774 \ud5c8\uc6a9\ub418\uc5c8\ub2e4. expr<\/em> \uac00 DATE \ub610\ub294 DATETIME \ud615\uc2dd\uc77c \ub54c, days<\/em> \ub294 expr<\/em> \uc5d0 \ucd94\uac00\ub418\ub294 \uc77c\uc218\uc774\ub2e4.<\/p>\n
mysql> SELECT ADDDATE('1998-01-02', 31);\r\n        -> '1998-02-02'\r\n<\/pre>\n
ADDTIME(expr<\/em>,expr2<\/em>)<\/h2>\n
ADDTIME()\ub294 expr<\/em> \uc5d0 expr2<\/em> \ub97c \ub354\ud558\uace0 \uadf8 \uacb0\uacfc\ub97c \ubc18\ud658\ud55c\ub2e4. expr<\/em> \ub294 TIME \ub610\ub294 DATETIME \ud615\uc2dd\uc774\uace0, expr2<\/em> \ub294 \uc2dc\uac04 \ud45c\ud604\uc774\ub2e4.<\/p>\n
mysql> SELECT ADDTIME('1997-12-31 23:59:59.999999', '1 1:1:1.000002');\r\n        -> '1998-01-02 01:01:01.000001'\r\nmysql> SELECT ADDTIME('01:00:00.999999', '02:00:00.999998');\r\n        -> '03:00:01.999997'\r\n<\/pre>\n
ADDTIME()\ub294 MySQL 4.1.1 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n
CONVERT_TZ(dt<\/em>,from_tz<\/em>,to_tz<\/em>)<\/h2>\n
CONVERT_TZ()\ub294 DATETIME \uac12 dt<\/em> \ub97c from_tz<\/em> \uc2dc\uac04\ub300\uc5d0\uc11c to_tz<\/em> \uc2dc\uac04\ub300\ub85c \ubcc0\ud658\ud558\uace0, \uacb0\uacfc\uac12\uc744 \ubc18\ud658\ud55c\ub2e4. \uc774 \ud568\uc218\ub294 \uc778\uc790\uac00 \uc720\ud6a8\ud558\uc9c0 \uc54a\uc73c\uba74 NULL \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
from_tz<\/em> \uc5d0\uc11c UTC\uc73c\ub85c \ubcc0\ud658\ub420 \ub54c \uc785\ub825\uac12\uc774 TIMESTAMP \ud615\uc758 \ubc94\uc704\ub97c \ubc97\uc5b4\ub098\uba74 \ubcc0\ud658\uc740 \uc77c\uc5b4\ub098\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n
mysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','GMT','MET');\r\n        -> '2004-01-01 13:00:00'\r\nmysql> SELECT CONVERT_TZ('2004-01-01 12:00:00','+00:00','-07:00');\r\n        -> '2004-01-01 05:00:00'\r\n<\/pre>\n
‘MET’\uc774\ub098 ‘Europe\/Moscow’\uc640 \uac19\uc740 \uc2dc\uac04\ub300\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c\ub294, \uc2dc\uac04\ub300 \ud45c\uac00 \uc801\uc808\ud558\uac8c \uc124\uc815\ub418\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n
CONVERT_TZ()\ub294 MySQL 4.1.3 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n
CURDATE()<\/h2>\n
\ud568\uc218\uac00 \ubb38\uc790\uc5f4\uc774\ub098 \uc22b\uc790\ub85c \uc0ac\uc6a9\ub418\uc5c8\ub294\uc9c0 \ubb38\ub9e5\uc5d0 \ub530\ub77c\uc11c ‘YYYY-MM-DD’\uc774\ub098 YYYYMMDD \ud615\uc2dd\uc73c\ub85c \ud604\uc7ac \ub0a0\uc9dc\ub97c \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT CURDATE();\r\n        -> '1997-12-15'\r\nmysql> SELECT CURDATE() + 0;\r\n        -> 19971215\r\n<\/pre>\n
CURRENT_DATE , CURRENT_DATE()<\/h2>\n
CURRENT_DATE\uc640 CURRENT_DATE()\ub294 CURDATE()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4.<\/p>\n
CURTIME()<\/h2>\n
\ud568\uc218\uac00 \ubb38\uc790\uc5f4\uc774\ub098 \uc22b\uc790\ub85c \uc0ac\uc6a9\ub418\uc5c8\ub294\uc9c0 \ubb38\ub9e5\uc5d0 \ub530\ub77c\uc11c ‘HH:MM:SS’\uc774\ub098 HHMMSS \ud615\uc2dd\uc73c\ub85c \ud604\uc7ac \uc2dc\uac04\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT CURTIME();\r\n        -> '23:50:26'\r\nmysql> SELECT CURTIME() + 0;\r\n        -> 235026\r\n<\/pre>\n
CURRENT_TIME , CURRENT_TIME()<\/h2>\n
CURRENT_TIME\uc640 CURRENT_TIME()\ub294 CURTIME()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4.<\/p>\n
CURRENT_TIMESTAMP , CURRENT_TIMESTAMP()<\/h2>\n
CURRENT_TIMESTAMP\uc640 CURRENT_TIMESTAMP()\ub294 NOW()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4.<\/p>\n
DATE(expr<\/em>)<\/h2>\n
\ub0a0\uc9dc(date)\ub098 DATETIME \ud45c\ud604 expr<\/em> \uc5d0\uc11c DATE \ubd80\ubd84\uc744 \ucd94\ucd9c\ud55c\ub2e4.<\/p>\n
mysql> SELECT DATE('2003-12-31 01:02:03');\r\n        -> '2003-12-31'\r\n<\/pre>\n
DATE()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
DATEDIFF(expr<\/em>,expr2<\/em>)<\/h2>\n
DATEDIFF()\ub294 \uc2dc\uc791 \ub0a0\uc9dc expr<\/em> \uc640 \ub9c8\uc9c0\ub9c9 \ub0a0\uc9dc expr2<\/em> \uc0ac\uc774\uc758 \uc77c\uc218\ub97c \ubc18\ud658\ud55c\ub2e4. expr<\/em> \uc640 expr2<\/em> \ub294 \ub0a0\uc9dc(date) \ub610\ub294 date-and-time \ud45c\ud604\uc774\ub2e4. \ubc18\ud658\uac12\uc758 DATE \ubd80\ubd84\ub9cc \uacc4\uc0b0\ub41c\ub2e4.<\/p>\n
mysql> SELECT DATEDIFF('1997-12-31 23:59:59','1997-12-30');\r\n        -> 1\r\nmysql> SELECT DATEDIFF('1997-11-30 23:59:59','1997-12-31');\r\n        -> -31\r\n<\/pre>\n
DATEDIFF()\ub294 MySQL 4.1.1 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n
DATE_ADD(date<\/em>,INTERVAL expr type<\/em>) , DATE_SUB<\/strong>(date<\/em>,INTERVAL expr type<\/em>)<\/h2>\n
\uc774 \ud568\uc218\ub4e4\uc740 \ub0a0\uc9dc \uacc4\uc0b0\uc744 \uc218\ud589\ud55c\ub2e4. date<\/em> \ub294 \uc2dc\uc791 \ub0a0\uc9dc\ub97c \uc9c0\uc815\ud558\ub294 DATETIME \ub610\ub294 DATE \uac12\uc774\ub2e4. expr<\/em> \ub294 \uc2dc\uc791 \ub0a0\uc9dc\ub85c\ubd80\ud130 \ub354\ud558\uac70\ub098 \ube80 \uac04\uaca9 \uac12\uc744 \uc9c0\uc815\ud558\ub294 \ud45c\ud604\uc774\ub2e4. expr<\/em> \ub294 \ubb38\uc790\uc5f4\uc774\ub2e4. \ub9c8\uc774\ub108\uc2a4(‘-‘)\ub85c \uc2dc\uc791\ub420 \uc218\ub3c4 \uc788\ub2e4. type<\/em> \ub294 \uc5b4\ub5bb\uac8c \ud574\uc11d\ud560\uc9c0\ub97c \uc9c0\uc815\ud558\ub294 \ud0a4\uc6cc\ub4dc\uc774\ub2e4.<\/p>\n
INTERVAL \ud0a4\uc6cc\ub4dc\uc640 type<\/em> \uc9c0\uc815\uc790\ub294 \ub300\uc18c\ubb38\uc790\ub97c \uad6c\ubd84\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n
\ub2e4\uc74c \ud45c\ub294 type<\/em> \uc640 expr<\/em> \uc778\uc790\uac00 \uc5b4\ub5a4 \uad00\uacc4\uc778\uc9c0 \ubcf4\uc5ec\uc900\ub2e4.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
type<\/em> \uac12<\/th>\n\uae30\ub300\ub418\ub294 expr<\/em> \ud615\uc2dd<\/th>\n<\/tr>\n
MICROSECOND<\/td>\nMICROSECONDS<\/td>\n<\/tr>\n
SECOND<\/td>\nSECONDS<\/td>\n<\/tr>\n
MINUTE<\/td>\nMINUTES<\/td>\n<\/tr>\n
HOUR<\/td>\nHOURS<\/td>\n<\/tr>\n
DAY<\/td>\nDAYS<\/td>\n<\/tr>\n
WEEK<\/td>\nWEEKS<\/td>\n<\/tr>\n
MONTH<\/td>\nMONTHS<\/td>\n<\/tr>\n
QUARTER<\/td>\nQUARTERS<\/td>\n<\/tr>\n
YEAR<\/td>\nYEARS<\/td>\n<\/tr>\n
SECOND_MICROSECOND<\/td>\n‘SECONDS.MICROSECONDS’<\/td>\n<\/tr>\n
MINUTE_MICROSECOND<\/td>\n‘MINUTES.MICROSECONDS’<\/td>\n<\/tr>\n
MINUTE_SECOND<\/td>\n‘MINUTES:SECONDS’<\/td>\n<\/tr>\n
HOUR_MICROSECOND<\/td>\n‘HOURS.MICROSECONDS’<\/td>\n<\/tr>\n
HOUR_SECOND<\/td>\n‘HOURS:MINUTES:SECONDS’<\/td>\n<\/tr>\n
HOUR_MINUTE<\/td>\n‘HOURS:MINUTES’<\/td>\n<\/tr>\n
DAY_MICROSECOND<\/td>\n‘DAYS.MICROSECONDS’<\/td>\n<\/tr>\n
DAY_SECOND<\/td>\n‘DAYS HOURS:MINUTES:SECONDS’<\/td>\n<\/tr>\n
DAY_MINUTE<\/td>\n‘DAYS HOURS:MINUTES’<\/td>\n<\/tr>\n
DAY_HOUR<\/td>\n‘DAYS HOURS’<\/td>\n<\/tr>\n
YEAR_MONTH<\/td>\n‘YEARS-MONTHS’<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
type<\/em> \uac12 DAY_MICROSECOND, HOUR_MICROSECOND, MINUTE_MICROSECOND, SECOND_MICROSECOND, MICROSECOND \ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4. \uac12 QUARTER\uacfc WEEK\ub294 MySQL 5.0.0 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
MySQL\uc740 expr<\/em> \ud615\uc2dd \uc548\uc5d0\uc11c \uc5b4\ub5a4 \uad6c\ubb38 \uad6c\ud68d\uc790\ub3c4 \ud5c8\uc6a9\ud55c\ub2e4. \ud45c\uc5d0\uc11c \ubcfc \uc218 \uc788\ub294 \uac83\ub4e4\uc740 \uc81c\uc548\ub41c \uad6c\ud68d\uc790\ub4e4\uc774\ub2e4. date<\/em> \uc778\uc790\uac00 DATE \uac12\uc774\uace0 \ub2e8\uc9c0 YEAR, MONTH, DAY \ub9cc \uacc4\uc0b0\ud558\uace0\uc790 \ud55c\ub2e4\uba74(TIME \ubd80\ubd84\uc774 \ud544\uc694 \uc5c6\ub2e4\uba74), \uacb0\uacfc\ub294 DATE \uac12\uc774\ub2e4. \uadf8\ub807\uc9c0 \uc54a\ub2e4\uba74, \uacb0\uacfc\ub294 DATETIME \uac12\uc774\ub2e4.<\/p>\n
MySQL 3.23 \ubc84\uc804\ubd80\ud130, INTERVAL expr type<\/em> \ub294 \ub2e4\ub978 \ubd80\ubd84\uc774 DATE \ub610\ub294 DATETIME \uac12\uc73c\ub85c \ud45c\ud604\ub418\uc5b4 \uc788\ub2e4\uba74 \uc5b4\ub290 \ud55c\ucabd\uc774\ub77c\ub3c4 + \uc5f0\uc0b0\uc790\uc758 \uc0ac\uc6a9\uc744 \ud5c8\uc6a9\ud55c\ub2e4. – \uc5f0\uc0b0\uc790\ub294 \uc624\ub978\ucabd\uc5d0\ub9cc \ud5c8\uc6a9\ub41c\ub2e4. \uac04\uaca9\uc5d0\uc11c DATE \ub610\ub294 DATETIME \uac12\uc744 \ube7c\ub294 \uac83\uc740 \ubb34\uc758\ubbf8\ud558\uae30 \ub54c\ubb38\uc774\ub2e4. (\uc544\ub798 \uc608\ubb38\uc744 \ucc38\uc870\ud558\ub77c.)<\/p>\n
mysql> SELECT '1997-12-31 23:59:59' + INTERVAL 1 SECOND;\r\n        -> '1998-01-01 00:00:00'\r\nmysql> SELECT INTERVAL 1 DAY + '1997-12-31';\r\n        -> '1998-01-01'\r\nmysql> SELECT '1998-01-01' - INTERVAL 1 SECOND;\r\n        -> '1997-12-31 23:59:59'\r\nmysql> SELECT DATE_ADD('1997-12-31 23:59:59', INTERVAL 1 SECOND);\r\n        -> '1998-01-01 00:00:00'\r\nmysql> SELECT DATE_ADD('1997-12-31 23:59:59', INTERVAL 1 DAY);\r\n        -> '1998-01-01 23:59:59'\r\nmysql> SELECT DATE_ADD('1997-12-31 23:59:59', INTERVAL '1:1' MINUTE_SECOND);\r\n        -> '1998-01-01 00:01:00'\r\nmysql> SELECT DATE_SUB('1998-01-01 00:00:00', INTERVAL '1 1:1:1' DAY_SECOND);\r\n        -> '1997-12-30 22:58:59'\r\nmysql> SELECT DATE_ADD('1998-01-01 00:00:00', INTERVAL '-1 10' DAY_HOUR);\r\n        -> '1997-12-30 14:00:00'\r\nmysql> SELECT DATE_SUB('1998-01-02', INTERVAL 31 DAY);\r\n        -> '1997-12-02'\r\nmysql> SELECT DATE_ADD('1992-12-31 23:59:59.000002', INTERVAL '1.999999' SECOND_MICROSECOND);\r\n        -> '1993-01-01 00:00:01.000001'\r\n<\/pre>\n
\uc9c0\uc815\ud55c \uac04\uaca9(interval) \uac12\uc774 \ub108\ubb34 \uc9e7\ub2e4\uba74(type<\/em> \ud0a4\uc6cc\ub4dc\ub85c\ubd80\ud130 \uae30\ub300\ub418\ub294 \ubaa8\ub4e0 \uac04\uaca9 \ubd80\ubd84\uc774 \ud3ec\ud568\ub418\uc5b4 \uc788\uc9c0 \uc54a\ub2e4\uba74), MySQL\uc740 \uac04\uaca9 \uac12\uc758 \uc67c\ucabd \ubd80\ubd84\uc744 \ub0a8\uacbc\ub2e4\uace0 \uac00\uc815\ud55c\ub2e4. \uc608\ub97c \ub4e4\uc5b4, type<\/em> DAY_SECOND\ub97c \uc9c0\uc815\ud588\ub2e4\uba74, expr<\/em> \uac12\uc740 \uc77c, \uc2dc, \ubd84, \ucd08 \ubd80\ubd84\uc774 \uae30\ub300\ub41c\ub2e4. ‘1:10’\uacfc \uac19\uc740 \uac12\uc744 \uc9c0\uc815\ud588\ub2e4\uba74, MySQL\uc740 \uc77c, \uc2dc \ubd80\ubd84\uc774 \uc5c6\ub294 \ubd84, \ucd08 \uac12\uc774\ub77c\uace0 \uac00\uc815\ud55c\ub2e4. \ub2e4\ub974\uac8c \ub9d0\ud558\uba74, ‘1:10’ DAY_SECOND\ub294 ‘1:10’ MINUTE_SECOND\uacfc \ub3d9\uc77c\ud55c \uac12\uc73c\ub85c \ud574\uc11d\ub41c\ub2e4. \uc774\uac83\uc740 MySQL\uac00 TIME \uac12\uc744 \uc2dc\uac01\ubcf4\ub2e4 \uc2dc\uac04\uc73c\ub85c \ud574\uc11d\ud558\ub294 \uac83\uacfc \ube44\uc2b7\ud558\ub2e4.<\/p>\n
TIME \ubd80\ubd84\uc744 \ud3ec\ud568\ud558\ub294 \uc5b4\ub5a4 \uac12\uc5d0\uc11c date<\/em> \ub97c \ub354\ud558\uac70\ub098 \ube80\ub2e4\uba74, \uacb0\uacfc\ub294 \uc790\ub3d9\uc73c\ub85c DATETIME \uac12\uc73c\ub85c \ubcc0\ud658\ub41c\ub2e4.<\/p>\n
mysql> SELECT DATE_ADD('1999-01-01', INTERVAL 1 DAY);\r\n        -> '1999-01-02'\r\nmysql> SELECT DATE_ADD('1999-01-01', INTERVAL 1 HOUR);\r\n        -> '1999-01-01 01:00:00'\r\n<\/pre>\n
\uae30\ud615\uc801\uc778 \ub0a0\uc9dc\ub97c \uc785\ub825\ud558\uba74 \uacb0\uacfc\ub294 NULL\uc774 \ub41c\ub2e4. \ub9cc\uc77c MONTH, YEAR_MONTH, \ub610\ub294 YEAR\ub97c \ub354\ud574\uc11c \uc0c8\ub85c\uc6b4 \ub2ec\uc758 \uc77c\uc218\ubcf4\ub2e4 \ub354 \ud070 \ub0a0\uc9dc\uac00 \ub41c\ub2e4\uba74, \ub0a0\uc9dc\ub294 \uc0c8\ub85c\uc6b4 \ub2ec\uc758 \ub9c8\uc9c0\ub9c9 \ub0a0\ub85c \ubcf4\uc815\ub41c\ub2e4.<\/p>\n
mysql> SELECT DATE_ADD('1998-01-30', INTERVAL 1 MONTH);\r\n        -> '1998-02-28'\r\n<\/pre>\n
DATE_FORMAT(date<\/em>,format<\/em>)<\/h2>\n
format<\/em> \ubb38\uc790\uc5f4\uc5d0 \ub530\ub77c date<\/em> \uac12\uc744 \ud615\uc2dd\ud654\ud55c\ub2e4. format<\/em> \ubb38\uc790\uc5f4\uc5d0\ub294 \ub2e4\uc74c \uc9c0\uc815\uc790\ub4e4\uc774 \uc0ac\uc6a9\ub41c\ub2e4.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\uc9c0\uc815\uc790<\/th>\n\uc124\uba85<\/th>\n<\/tr>\n
%a<\/td>\nAbbreviated weekday name (Sun..Sat)<\/td>\n<\/tr>\n
%b<\/td>\nAbbreviated month name (Jan..Dec)<\/td>\n<\/tr>\n
%c<\/td>\nMonth, numeric (0..12)<\/td>\n<\/tr>\n
%D<\/td>\nDay of the month with English suffix (0th, 1st, 2nd, 3rd, …)<\/td>\n<\/tr>\n
%d<\/td>\nDay of the month, numeric (00..31)<\/td>\n<\/tr>\n
%e<\/td>\nDay of the month, numeric (0..31)<\/td>\n<\/tr>\n
%f<\/td>\nMicroseconds (000000..999999)<\/td>\n<\/tr>\n
%H<\/td>\nHour (00..23)<\/td>\n<\/tr>\n
%h<\/td>\nHour (01..12)<\/td>\n<\/tr>\n
%I<\/td>\nHour (01..12)<\/td>\n<\/tr>\n
%i<\/td>\nMinutes, numeric (00..59)<\/td>\n<\/tr>\n
%j<\/td>\nDay of year (001..366)<\/td>\n<\/tr>\n
%k<\/td>\nHour (0..23)<\/td>\n<\/tr>\n
%l<\/td>\nHour (1..12)<\/td>\n<\/tr>\n
%M<\/td>\nMonth name (January..December)<\/td>\n<\/tr>\n
%m<\/td>\nMonth, numeric (00..12)<\/td>\n<\/tr>\n
%p<\/td>\nAM or PM<\/td>\n<\/tr>\n
%r<\/td>\nTime, 12-hour (hh:mm:ss followed by AM or PM)<\/td>\n<\/tr>\n
%S<\/td>\nSeconds (00..59)<\/td>\n<\/tr>\n
%s<\/td>\nSeconds (00..59)<\/td>\n<\/tr>\n
%T<\/td>\nTime, 24-hour (hh:mm:ss)<\/td>\n<\/tr>\n
%U<\/td>\nWeek (00..53), where Sunday is the first day of the week<\/td>\n<\/tr>\n
%u<\/td>\nWeek (00..53), where Monday is the first day of the week<\/td>\n<\/tr>\n
%V<\/td>\nWeek (01..53), where Sunday is the first day of the week; used with %X<\/td>\n<\/tr>\n
%v<\/td>\nWeek (01..53), where Monday is the first day of the week; used with %x<\/td>\n<\/tr>\n
%W<\/td>\nWeekday name (Sunday..Saturday)<\/td>\n<\/tr>\n
%w<\/td>\nDay of the week (0=Sunday..6=Saturday)<\/td>\n<\/tr>\n
%X<\/td>\nYear for the week where Sunday is the first day of the week, numeric, four digits; used with %V<\/td>\n<\/tr>\n
%x<\/td>\nYear for the week, where Monday is the first day of the week, numeric, four digits; used with %v<\/td>\n<\/tr>\n
%Y<\/td>\nYear, numeric, four digits<\/td>\n<\/tr>\n
%y<\/td>\nYear, numeric, two digits<\/td>\n<\/tr>\n
%%<\/td>\nA literal ‘%’.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\ub2e4\ub978 \ubaa8\ub4e0 \ubb38\uc790\ub4e4\uc740 \ubcc0\ud658\uc5c6\uc774 \uacb0\uacfc\uc5d0 \uadf8\ub300\ub85c \ubcf5\uc0ac\ub41c\ub2e4.<\/p>\n
%v, %V, %x, %X format<\/em> \uc9c0\uc815\uc790\ub4e4\uc740 MySQL 3.23.8 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\uace0, %f\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
MySQL 3.23 \ubc84\uc804\ubd80\ud130\ub294 ‘%’ \ubb38\uc790\uac00 format<\/em> \uc9c0\uc815\ubb38\uc790 \uc55e\uc5d0 \uc694\uad6c\ub41c\ub2e4. \uadf8 \uc774\uc804 \ubc84\ubc88\uc5d0\uc11c ‘%’\ub294 \uc120\ud0dd\uc0ac\uc591\uc774\ub2e4.<\/p>\n
\uc6d4\uc77c\uc758 \ubc94\uc704\uac00 ‘0’\uc73c\ub85c \uc2dc\uc791\ub418\uae30 \ub54c\ubb38\uc5d0 MySQL 3.23 \ubc84\uc804\ubd80\ud130\ub294 ‘2004-00-00’\uc640 \uac19\uc740 \ubd88\uc644\uc804\ud55c \ub0a0\uc9dc\uac00 \ud5c8\uc6a9\ub41c\ub2e4.<\/p>\n
mysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');\r\n        -> 'Saturday October 1997'\r\nmysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s');\r\n        -> '22:23:00'\r\nmysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%D %y %a %d %m %b %j');\r\n        -> '4th 97 Sat 04 10 Oct 277'\r\nmysql> SELECT DATE_FORMAT('1997-10-04 22:23:00', '%H %k %I %r %T %S %w');\r\n        -> '22 22 10 10:23:00 PM 22:23:00 00 6'\r\nmysql> SELECT DATE_FORMAT('1999-01-01', '%X %V');\r\n        -> '1998 52'\r\n<\/pre>\n
DAY(date<\/em>)<\/h2>\n
DAY()\ub294 DAYOFMONTH()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4. MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
DAYNAME(date<\/em>)<\/h2>\n
date<\/em> \uc5d0 \ub300\ud55c \uc694\uc77c \uc774\ub984\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT DAYNAME('1998-02-05');\r\n        -> 'Thursday'\r\n<\/pre>\n
DAYOFMONTH(date<\/em>)<\/h2>\n
date<\/em> \uc5d0 \ub300\ud55c \ub2f9\uc6d4\uc758 \ub0a0\uc9dc\ub97c \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 1~31)<\/p>\n
mysql> SELECT DAYOFMONTH('1998-02-03');\r\n        -> 3\r\n<\/pre>\n
DAYOFWEEK(date<\/em>)<\/h2>\n
date<\/em> \uc5d0 \ub300\ud558\uc5ec \uc694\uc77c \uc0c9\uc778(1 = \uc77c\uc694\uc77c, 2 = \uc6d4\uc694\uc77c, …, 7 = \ud1a0\uc694\uc77c)\uc744 \ubc18\ud658\ud55c\ub2e4. \uc774 \uc0c9\uc778\uac12\ub4e4\uc740 ODBC \ud45c\uc900\uc5d0 \ub530\ub978\ub2e4.<\/p>\n
mysql> SELECT DAYOFWEEK('1998-02-03');\r\n        -> 3\r\n<\/pre>\n
DAYOFYEAR(date<\/em>)<\/h2>\n
date<\/em> \uac00 \ud574\ub2f9 \uc5f0\ub3c4\uc5d0 \uba87\uc77c\uc9f8\uc778\uc9c0 \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 1~366)<\/p>\n
mysql> SELECT DAYOFYEAR('1998-02-03');\r\n        -> 34\r\n<\/pre>\n
EXTRACT(type<\/em> FROM date<\/em>)<\/h2>\n
EXTRACT() \ud568\uc218\ub294 DATE_ADD()\ub098 DATE_SUB()\uc640 \uac19\uc740 \uc885\ub958\uc758 \uac04\uaca9 \uc9c0\uc815\uc790\ub97c \uc0ac\uc6a9\ud558\uc9c0\ub9cc, \ub0a0\uc9dc\ub97c \uacc4\uc0b0\ud558\ub294 \uac8c \uc544\ub2c8\ub77c \ub0a0\uc9dc\ub85c\ubd80\ud130 \ubd80\ubd84\uc744 \ucd94\ucd9c\ud55c\ub2e4.<\/p>\n
mysql> SELECT EXTRACT(YEAR FROM '1999-07-02');\r\n       -> 1999\r\nmysql> SELECT EXTRACT(YEAR_MONTH FROM '1999-07-02 01:02:03');\r\n       -> 199907\r\nmysql> SELECT EXTRACT(DAY_MINUTE FROM '1999-07-02 01:02:03');\r\n       -> 20102\r\nmysql> SELECT EXTRACT(MICROSECOND FROM '2003-01-02 10:30:00.00123');\r\n        -> 123\r\n<\/pre>\n
EXTRACT()\ub294 MySQL 3.23.0 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n
FROM_DAYS(N<\/em>)<\/h2>\n
\uc77c\uc218 N<\/em> \uac00 \uc8fc\uc5b4\uc9c0\uba74, DATE \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT FROM_DAYS(729669);\r\n        -> '1997-10-07'\r\n<\/pre>\n
FROM_DAYS()\ub294 \uadf8\ub808\uace0\ub9ac\uc548 \ub2ec\ub825\uc758 \ucd9c\ud604(1582\ub144) \uc774\uc804\uc758 \uac12\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \uacc4\ud68d\ub418\uc9c0 \uc54a\uc558\ub2e4. \ub2ec\ub825\uc774 \ubc14\ub00c\uc5c8\uc744 \ub54c \uc190\uc2e4\ub41c \ub0a0\uc9dc\ub294 \uace0\ub824\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n
FROM_UNIXTIME(unix_timestamp<\/em>) , FROM_UNIXTIME(unix_timestamp<\/em>,format<\/em>)<\/h2>\n
\ud568\uc218\uc5d0 \uc0ac\uc6a9\ub41c \ubb38\ub9e5\uc774 \ubb38\uc790\uc5f4\uc778\uc9c0 \uc22b\uc790\uc778\uc9c0\uc5d0 \ub530\ub77c ‘YYYY-MM-DD HH:MM:SS’ \ub610\ub294 YYYYMMDDHHMMSS format<\/em> \uac12\uc73c\ub85c unix_timestamp<\/em> \uc778\uc790\uac00 \ud45c\uc2dc\ub418\uc5b4 \ubc18\ud658\ub41c\ub2e4.<\/p>\n
mysql> SELECT FROM_UNIXTIME(875996580);\r\n        -> '1997-10-04 22:23:00'\r\nmysql> SELECT FROM_UNIXTIME(875996580) + 0;\r\n        -> 19971004222300\r\n<\/pre>\n
format<\/em> \uc774 \uc8fc\uc5b4\uc9c4\ub2e4\uba74 \uacb0\uacfc\ub294 format<\/em> \ubb38\uc790\uc5f4\uc5d0 \ub530\ub77c \ud615\uc2dd\ud654\ub41c\ub2e4. format<\/em> \uc740 DATE_FORMAT() \ud568\uc218\uc5d0 \uc4f0\uc774\ub294 \uc9c0\uc815\uc790\ub97c \ub611\uac19\uc774 \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n
mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(), '%Y %D %M %h:%i:%s %x');\r\n        -> '2003 6th August 06:22:58 2003'\r\n<\/pre>\n
GET_FORMAT(DATE|TIME|DATETIME, ‘EUR’|’USA’|’JIS’|’ISO’|’INTERNAL’)<\/h2>\n
\ud615\uc2dd \ubb38\uc790\uc5f4\uc744 \ubc18\ud658\ud55c\ub2e4. \uc774 \ud568\uc218\ub294 DATE_FORMAT()\uacfc STR_TO_DATE() \ud568\uc218\uc640 \uc870\ud569\ud560 \ub54c \uc720\uc6a9\ud558\ub2e4.<\/p>\n
\uccab\ubc88\uc9f8 \uc778\uc790\ub85c\ub294 3\uac00\uc9c0 \uac00\ub2a5\ud55c \uac12\uc774 \uc788\uace0, \ub450\ubc88\uc9f8 \uc778\uc790\ub85c\ub294 5\uac00\uc9c0 \uac00\ub2a5\ud55c \uac12\uc774 \uc788\uc5b4\uc11c \uacb0\uacfc\uc801\uc73c\ub85c 15\uac00\uc9c0 \ud615\uc2dd \ubb38\uc790\uc5f4\uc774 \uac00\ub2a5\ud558\ub2e4. (\uc0ac\uc6a9\ub418\ub294 \uc9c0\uc815\uc790\ub97c \uc704\ud574\uc11c DATE_FORMAT()<\/a> \uc124\uba85\uc744 \ucc38\uc870\ud558\ub77c.)<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\ud568\uc218 \ud638\ucd9c<\/th>\n\uacb0\uacfc<\/th>\n<\/tr>\n
GET_FORMAT(DATE,’USA’)<\/td>\n‘%m.%d.%Y’<\/td>\n<\/tr>\n
GET_FORMAT(DATE,’JIS’)<\/td>\n‘%Y-%m-%d’<\/td>\n<\/tr>\n
GET_FORMAT(DATE,’ISO’)<\/td>\n‘%Y-%m-%d’<\/td>\n<\/tr>\n
GET_FORMAT(DATE,’EUR’)<\/td>\n‘%d.%m.%Y’<\/td>\n<\/tr>\n
GET_FORMAT(DATE,’INTERNAL’)<\/td>\n‘%Y%m%d’<\/td>\n<\/tr>\n
GET_FORMAT(DATETIME,’USA’)<\/td>\n‘%Y-%m-%d-%H.%i.%s’<\/td>\n<\/tr>\n
GET_FORMAT(DATETIME,’JIS’)<\/td>\n‘%Y-%m-%d %H:%i:%s’<\/td>\n<\/tr>\n
GET_FORMAT(DATETIME,’ISO’)<\/td>\n‘%Y-%m-%d %H:%i:%s’<\/td>\n<\/tr>\n
GET_FORMAT(DATETIME,’EUR’)<\/td>\n‘%Y-%m-%d-%H.%i.%s’<\/td>\n<\/tr>\n
GET_FORMAT(DATETIME,’INTERNAL’)<\/td>\n‘%Y%m%d%H%i%s’<\/td>\n<\/tr>\n
GET_FORMAT(TIME,’USA’)<\/td>\n‘%h:%i:%s %p’<\/td>\n<\/tr>\n
GET_FORMAT(TIME,’JIS’)<\/td>\n‘%H:%i:%s’<\/td>\n<\/tr>\n
GET_FORMAT(TIME,’ISO’)<\/td>\n‘%H:%i:%s’<\/td>\n<\/tr>\n
GET_FORMAT(TIME,’EUR’)<\/td>\n‘%H.%i.%S’<\/td>\n<\/tr>\n
GET_FORMAT(TIME,’INTERNAL’)<\/td>\n‘%H%i%s’<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
ISO \ud615\uc2dd\uc740 ISO 8601\uc774 \uc544\ub2c8\ub77c ISO 9075\uc774\ub2e4.<\/p>\n
MySQL 4.1.4 \ubc84\uc804\ubd80\ud130\ub294 TIMESTAMP \ub610\ud55c \uc0ac\uc6a9\ud560 \uc218 \uc788\uac8c \ub418\uc5c8\ub2e4. GET_FORMAT() \ud568\uc218\ub294 \uac19\uc740 \uac12\uc744 DATETIME \ud615\uc2dd\uc73c\ub85c \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT DATE_FORMAT('2003-10-03',GET_FORMAT(DATE,'EUR'));\r\n        -> '03.10.2003'\r\nmysql> SELECT STR_TO_DATE('10.31.2003',GET_FORMAT(DATE,'USA'));\r\n        -> 2003-10-31\r\n<\/pre>\n
GET_FORMAT()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
HOUR(time<\/em>)<\/h2>\n
time<\/em> \uc5d0\uc11c \uc2dc\uac04\uc744 \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 0~23)<\/p>\n
mysql> SELECT HOUR('10:05:03');\r\n        -> 10\r\n<\/pre>\n
\uadf8\ub7ec\ub098 TIME \uac12\uc758 \ud06c\uae30\ub294 \uc2e4\uc81c\ub85c \ud6e8\uc52c \ub354 \ud06c\ub2e4. HOUR\ub294 23\ubcf4\ub2e4 \ub354 \ud070 \uac12\uc744 \ubc18\ud658\ud560 \uc218 \uc788\ub2e4.<\/p>\n
mysql> SELECT HOUR('272:59:59');\r\n        -> 272\r\n<\/pre>\n
LAST_DAY(date<\/em>)<\/h2>\n
DATE \ub610\ub294 DATETIME \uac12\uc744 \uc785\ub825\ud558\uba74 \ub2f9\uc6d4\uc758 \ub9c8\uc9c0\ub9c9 \ub0a0\uc5d0 \ub300\ud55c \uc0c1\uc751\ud558\ub294 \uac12\uc744 \ubc18\ud658\ud55c\ub2e4. \uc778\uc790\uac00 \uc720\ud6a8\ud558\uc9c0 \uc54a\uc73c\uba74 NULL\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT LAST_DAY('2003-02-05');\r\n        -> '2003-02-28'\r\nmysql> SELECT LAST_DAY('2004-02-05');\r\n        -> '2004-02-29'\r\nmysql> SELECT LAST_DAY('2004-01-01 01:01:01');\r\n        -> '2004-01-31'\r\nmysql> SELECT LAST_DAY('2003-03-32');\r\n        -> NULL\r\n<\/pre>\n
LAST_DAY()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
LOCALTIME , LOCALTIME()<\/h2>\n
LOCALTIME\uacfc LOCALTIME()\uc740 NOW()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4.<\/p>\n
\ub450 \ud568\uc218\ub294 MySQL 4.0.6 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n
LOCALTIMESTAMP , LOCALTIMESTAMP()<\/h2>\n
LOCALTIMESTAMP\uc640 LOCALTIMESTAMP()\ub294 NOW()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4.<\/p>\n
\ub450 \ud568\uc218\ub294 MySQL 4.0.6 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n
MAKEDATE(year<\/em>,dayofyear<\/em>)<\/h2>\n
year<\/em> \uc640 dayofyear<\/em> \uac12\uc774 \uc8fc\uc5b4\uc9c0\uba74 \ub0a0\uc9dc\ub97c \ubc18\ud658\ud55c\ub2e4. dayofyear<\/em> \ub294 0\ubcf4\ub2e4 \ucee4\uc57c \ud55c\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uc73c\uba74 \uacb0\uacfc\ub294 NULL\uc774\ub2e4.<\/p>\n
mysql> SELECT MAKEDATE(2001,31), MAKEDATE(2001,32);\r\n        -> '2001-01-31', '2001-02-01'\r\nmysql> SELECT MAKEDATE(2001,365), MAKEDATE(2004,365);\r\n        -> '2001-12-31', '2004-12-30'\r\nmysql> SELECT MAKEDATE(2001,0);\r\n        -> NULL\r\n<\/pre>\n
MAKEDATE()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
MAKETIME(hour<\/em>,minute<\/em>,second<\/em>)<\/h2>\n
hour<\/em>,minute<\/em>,second<\/em> \uc778\uc790\ub85c\ubd80\ud130 \uacc4\uc0b0\ub41c \uc2dc\uac04 \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT MAKETIME(12,15,30);\r\n        -> '12:15:30'\r\n<\/pre>\n
MAKETIME()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
MICROSECOND(expr<\/em>)<\/h2>\n
TIME \ub610\ub294 DATETIME \ud615\uc2dd\uc758 expr<\/em> \ub85c\ubd80\ud130 \ub9c8\uc774\ud06c\ub85c\ucd08\ub97c \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 0~999999)<\/p>\n
mysql> SELECT MICROSECOND('12:00:00.123456');\r\n        -> 123456\r\nmysql> SELECT MICROSECOND('1997-12-31 23:59:59.000010');\r\n        -> 10\r\n<\/pre>\n
MICROSECOND()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
MINUTE(time<\/em>)<\/h2>\n
time<\/em> \uc5d0 \ub300\ud558\uc5ec \uba87 \ubd84\uc778\uc9c0 \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 0~59)<\/p>\n
mysql> SELECT MINUTE('98-02-03 10:05:03');\r\n        -> 5\r\n<\/pre>\n
MONTH(date<\/em>)<\/h2>\n
date<\/em> \uc5d0 \ub300\ud558\uc5ec \uba87 \uc6d4\uc778\uc9c0 \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 1~12)<\/p>\n
mysql> SELECT MONTH('1998-02-03');\r\n        -> 2\r\n<\/pre>\n
MONTHNAME(date<\/em>)<\/h2>\n
date<\/em> \uc5d0 \ub300\ud558\uc5ec \ub2f9\uc6d4\uc758 \uc601\ubb38 \uc774\ub984\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT MONTHNAME('1998-02-05');\r\n        -> 'February'\r\n<\/pre>\n
NOW()<\/h2>\n
\ud568\uc218\uc5d0 \uc0ac\uc6a9\ub41c \ubb38\ub9e5\uc5d0 \ub530\ub77c ‘YYYY-MM-DD HH:MM:SS’ \ub610\ub294 YYYYMMDDHHMMSS \ud615\uc2dd\uc73c\ub85c \ud604\uc7ac \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT NOW();\r\n        -> '1997-12-15 23:50:26'\r\nmysql> SELECT NOW() + 0;\r\n        -> 19971215235026\r\n<\/pre>\n
PERIOD_ADD(P<\/em>,N<\/em>)<\/h2>\n
\uae30\uac04 P<\/em> \uc5d0 N<\/em> \uc6d4\uc744 \ub354\ud55c\ub2e4(YYMM \ub610\ub294 YYYYMM \ud615\uc2dd\uc73c\ub85c). YYYYMM \ud615\uc2dd\uc73c\ub85c \uacb0\uacfc\ub97c \ubc18\ud658\ud55c\ub2e4. \uae30\uac04 P<\/em> \uac00 DATE \uac12\uc774 \uc544\ub2c8\ub77c\ub294 \uac83\uc5d0 \uc8fc\uc758\ud558\ub77c.<\/p>\n
mysql> SELECT PERIOD_ADD(9801,2);\r\n        -> 199803\r\n<\/pre>\n
PERIOD_DIFF(P1<\/em>,P2<\/em>)<\/h2>\n
\uae30\uac04 P1<\/em>, P2<\/em> \uc0ac\uc774\uc758 \uac1c\uc6d4\uc218\ub97c \ubc18\ud658\ud55c\ub2e4. P1<\/em> \uacfc P2<\/em> \ub294 YYMM \ub610\ub294 YYYYMM \ud615\uc2dd\uc774\uc5b4\uc57c \ud55c\ub2e4. \uae30\uac04 P1<\/em>, P2<\/em> \uac00 DATE \uac12\uc774 \uc544\ub2c8\ub77c\ub294 \uac83\uc5d0 \uc8fc\uc758\ud558\ub77c.<\/p>\n
mysql> SELECT PERIOD_DIFF(9802,199703);\r\n        -> 11\r\n<\/pre>\n
QUARTER(date<\/em>)<\/h2>\n
date<\/em> \uac00 \uba87 \ubd84\uae30\uc778\uc9c0 \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 1~4)<\/p>\n
mysql> SELECT QUARTER('98-04-01');\r\n        -> 2\r\n<\/pre>\n
SECOND(time<\/em>)<\/h2>\n
time<\/em> \uc5d0\uc11c \ucd08 \uac12\uc744 \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 0~59)<\/p>\n
mysql> SELECT SECOND('10:05:03');\r\n        -> 3\r\n<\/pre>\n
SEC_TO_TIME(seconds<\/em>)<\/h2>\n
\ud568\uc218\uac00 \uc5b4\ub5a4 \ubb38\ub9e5\uc73c\ub85c \uc0ac\uc6a9\ub418\uc5c8\ub294\uc9c0\uc5d0 \ub530\ub77c seconds<\/em> \uc778\uc790\ub97c ‘HH:MM:SS’ \ub610\ub294 HHMMSS \ud615\uc2dd\uc73c\ub85c \ubcc0\ud658\uc2dc\ucf1c\uc11c \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT SEC_TO_TIME(2378);\r\n        -> '00:39:38'\r\nmysql> SELECT SEC_TO_TIME(2378) + 0;\r\n        -> 3938\r\n<\/pre>\n
STR_TO_DATE(str<\/em>,format<\/em>)<\/h2>\n
\uc774 \ud568\uc218\ub294 DATE_FORMAT() \ud568\uc218\uc758 \uc5ed\uae30\ub2a5\uc774\ub2e4. \ubb38\uc790\uc5f4 str<\/em> \uc640 \ud615\uc2dd \ubb38\uc790\uc5f4 format<\/em> \uc744 \uc785\ub825\ubc1b\ub294\ub2e4. STR_TO_DATE()\ub294 \ud615\uc2dd \ubb38\uc790\uc5f4\uc774 \ub0a0\uc9dc\uc640 \uc2dc\uac04\uc744 \ubaa8\ub450 \ud3ec\ud568\ud558\uace0 \uc788\ub2e4\uba74 DATETIME \uac12\uc744 \ubc18\ud658\ud55c\ub2e4. \uadf8\ub807\uc9c0 \uc54a\uace0 \ub0a0\uc9dc\ub098 \uc2dc\uac04 \ub458 \uc911 \ud55c \ubd80\ubd84\ub9cc\uc744 \ud3ec\ud568\ud55c\ub2e4\uba74 DATE \ub610\ub294 TIME \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
str<\/em> \uc5d0 \ud3ec\ud568\ub41c DATE, TIME \ub610\ub294 DATETIME \uac12\uc740 format<\/em> \uc5d0 \uc758\ud574 \uc9c0\uc815\ub41c \ud615\uc2dd\uc73c\ub85c \uc8fc\uc5b4\uc838\uc57c \ud55c\ub2e4. format<\/em> \uc5d0 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \uc9c0\uc815\uc790\uc5d0 \ub300\ud574\uc11c\ub294 DATE_FORMAT()<\/a> \uc124\uba85\uc744 \ucc38\uc870\ud558\ub77c. \ub2e4\ub978 \ubaa8\ub4e0 \ubb38\uc790\ub294 \ud574\uc11d\ub418\uc9c0 \uc54a\uace0 \uadf8\ub300\ub85c \ubc18\uc601\ub41c\ub2e4. \ub9cc\uc77c str<\/em> \uac00 \uc720\ud6a8\ud558\uc9c0 \uc54a\uc740 \uac12\uc744 \ud3ec\ud568\ud55c\ub2e4\uba74 NULL\uc774 \ubc18\ud658\ub41c\ub2e4. MySQL 5.0.3 \ubc84\uc804\ubd80\ud130\ub294 \uc798\ubabb\ub41c \uac12 \ub610\ud55c \uacbd\uace0\ub97c \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n
mysql> SELECT STR_TO_DATE('03.10.2003 09.20', '%d.%m.%Y %H.%i');\r\n        -> '2003-10-03 09:20:00'\r\nmysql> SELECT STR_TO_DATE('10arp', '%carp');\r\n        -> '0000-10-00 00:00:00'\r\nmysql> SELECT STR_TO_DATE('2003-15-10 00:00:00', '%Y-%m-%d %H:%i:%s');\r\n        -> NULL\r\n<\/pre>\n
\uc5b4\ub5a4 \ub2ec\uc758 \uc77c\uc218\ubcf4\ub2e4 \ud070 \uc77c\uc218\ub97c \uac00\uc9c4 \ub0a0\uc9dc\ub294 1-31 \ubc94\uc704 \uc548\uc5d0\uc11c \ud5c8\uc6a9\ub41c\ub2e4. \ub610\ud55c ‘0’\uc774\ub098 ‘0’\uac12\uc744 \uac00\uc9c4 \ub0a0\uc9dc\ub3c4 \ud5c8\uc6a9\ub41c\ub2e4.<\/p>\n
mysql> SELECT STR_TO_DATE('00\/00\/0000', '%m\/%d\/%Y');\r\n        -> '0000-00-00'\r\nmysql> SELECT STR_TO_DATE('04\/31\/2004', '%m\/%d\/%Y');\r\n        -> '2004-04-31'\r\n<\/pre>\n
STR_TO_DATE()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
SUBDATE(date<\/em>,INTERVAL expr type<\/em>) , SUBDATE(expr<\/em>,days<\/em>)<\/h2>\n
\ub450\ubc88\uc9f8 \uc778\uc790 INTERVAL \ud615\uc2dd\uc744 \ud3ec\ud568\ud558\uc5ec \uc0ac\uc6a9\ub418\uc5c8\uc744 \ub54c SUBDATE()\ub294 DATE_SUB()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4. INTERVAL \uc778\uc790\uc5d0 \ub300\ud55c \uc815\ubcf4\ub294 DATE_ADD()<\/a> \uc124\uba85\uc744 \ucc38\uc870\ud558\ub77c.<\/p>\n
mysql> SELECT DATE_SUB('1998-01-02', INTERVAL 31 DAY);\r\n        -> '1997-12-02'\r\nmysql> SELECT SUBDATE('1998-01-02', INTERVAL 31 DAY);\r\n        -> '1997-12-02'\r\n<\/pre>\n
MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \ub450\ubc88\uc9f8 \ubb38\ubc95\uc774 \ud5c8\uc6a9\ub41c\ub2e4. expr<\/em> \ub294 DATE \ub610\ub294 DATETIME \ud615\uc2dd\uc774\uace0 days<\/em> \ub294 expr<\/em> \uc5d0\uc11c \ube84 \uc77c\uc218\uc774\ub2e4.<\/p>\n
mysql> SELECT SUBDATE('1998-01-02 12:00:00', 31);\r\n        -> '1997-12-02 12:00:00'\r\n<\/pre>\n
SUBTIME(expr<\/em>,expr2<\/em>)<\/h2>\n
SUBTIME()\ub294 expr<\/em> \uc5d0\uc11c expr2<\/em> \ub97c \ube7c\uace0 \uadf8 \uac12\uc744 \ubc18\ud658\ud55c\ub2e4. expr<\/em> \ub294 TIME \ub610\ub294 DATETIME \ud615\uc2dd\uc774\uace0, expr2<\/em> \ub294 TIME \ud615\uc2dd\uc774\ub2e4.<\/p>\n
mysql> SELECT SUBTIME('1997-12-31 23:59:59.999999',\r\n    ->                '1 1:1:1.000002');\r\n        -> '1997-12-30 22:58:58.999997'\r\nmysql> SELECT SUBTIME('01:00:00.999999', '02:00:00.999998');\r\n        -> '-00:59:59.999999'\r\n<\/pre>\n
SUBTIME()\ub294 MySQL 4.1.1 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n
SYSDATE()<\/h2>\n
SYSDATE()\ub294 NOW()<\/a>\uc758 \ubcc4\uce6d\uc774\ub2e4.<\/p>\n
TIME(expr<\/em>)<\/h2>\n
TIME \ub610\ub294 DATETIME \ud615\uc2dd\uc758 expr<\/em> \uc5d0\uc11c TIME \ubd80\ubd84\uc744 \ucd94\ucd9c\ud55c\ub2e4.<\/p>\n
mysql> SELECT TIME('2003-12-31 01:02:03');\r\n        -> '01:02:03'\r\nmysql> SELECT TIME('2003-12-31 01:02:03.000123');\r\n        -> '01:02:03.000123'\r\n<\/pre>\n
TIME()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
TIMEDIFF(expr<\/em>,expr2<\/em>)<\/h2>\n
TIMEDIFF()\ub294 \uc2dc\uc791 \uc2dc\uac04 expr<\/em> \uc640 \ub9c8\uc9c0\ub9c9 \uc2dc\uac04 expr2<\/em> \uc640\uc758 \ucc28\uc774\ub97c TIME \uac12\uc73c\ub85c \ubc18\ud658\ud55c\ub2e4. expr<\/em> \uc640 expr2<\/em> \ub294 TIME \ub610\ub294 DATETIME \ud615\uc2dd\uc774\uace0, \ub450 \ud615\uc2dd\uc740 \uac19\uc544\uc57c \ud55c\ub2e4.<\/p>\n
mysql> SELECT TIMEDIFF('2000:01:01 00:00:00',\r\n    ->                 '2000:01:01 00:00:00.000001');\r\n        -> '-00:00:00.000001'\r\nmysql> SELECT TIMEDIFF('1997-12-31 23:59:59.000001',\r\n    ->                 '1997-12-30 01:01:01.000002');\r\n        -> '46:58:57.999999'\r\n<\/pre>\n
TIMEDIFF()\ub294 MySQL 4.1.1 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n
TIMESTAMP(expr<\/em>) , TIMESTAMP(expr<\/em>,expr2<\/em>)<\/h2>\n
\uc778\uc790 \ud558\ub098\ub9cc\uc744 \uc0ac\uc6a9\ud55c\ub2e4\uba74, DATE \ub610\ub294 DATETIME expr<\/em> \ub97c DATETIME \uac12\uc73c\ub85c \ubc18\ud658\ud55c\ub2e4. \uc778\uc790 \ub450 \uac1c\ub97c \uc0ac\uc6a9\ud55c\ub2e4\uba74, DATE \ub610\ub294 DATETIME \ud615\uc2dd\uc758 expr<\/em> \uc5d0 TIME \ud615\uc2dd\uc758 expr2<\/em> \ub97c \ub354\ud558\uace0 \uadf8 DATETIME \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT TIMESTAMP('2003-12-31');\r\n        -> '2003-12-31 00:00:00'\r\nmysql> SELECT TIMESTAMP('2003-12-31 12:00:00','12:00:00');\r\n        -> '2004-01-01 00:00:00'\r\n<\/pre>\n
TIMESTAMP()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
TIMESTAMPADD(interval<\/em>,int_expr<\/em>,DATETIME_expr<\/em>)<\/h2>\n
DATE \ub610\ub294 DATETIME \ud615\uc2dd\uc758 DATETIME_expr<\/em> \uc5d0 \uc815\uc218 \ud615\uc2dd\uc758 int_expr<\/em> \ub97c \ub354\ud55c\ub2e4. int_expr<\/em> \uc758 \ub2e8\uc704\ub294 interval<\/em> \uc778\uc790\ub85c \uc8fc\uc5b4\uc9c0\ub294\ub370, \ub2e4\uc74c \uac12 \uac00\uc6b4\ub370 \ud558\ub098\uc774\uc5b4\uc57c \ud55c\ub2e4. FRAC_SECOND, SECOND, MINUTE, HOUR, DAY, WEEK, MONTH, QUARTER, YEAR.<\/p>\n
interval<\/em> \uac12\uc740 \uc0c1\uae30\ub41c \ud0a4\uc6cc\ub4dc \uac00\uc6b4\ub370 \ud558\ub098\ub97c \uc9c0\uc815\ud558\uac70\ub098 SQL_TSI_ \uc811\ub450\uc0ac\ub97c \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4. \uc608\ub97c \ub4e4\uc5b4, DAY \ub610\ub294 SQL_TSI_DAY \ub458 \ub2e4 \ubaa8\ub450 \ud5c8\uc6a9\ub41c\ub2e4.<\/p>\n
mysql> SELECT TIMESTAMPADD(MINUTE,1,'2003-01-02');\r\n        -> '2003-01-02 00:01:00'\r\nmysql> SELECT TIMESTAMPADD(WEEK,1,'2003-01-02');\r\n        -> '2003-01-09'\r\n<\/pre>\n
TIMESTAMPADD()\ub294 MySQL 5.0.0 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
TIMESTAMPDIFF(interval<\/em>,DATETIME_expr1<\/em>,DATETIME_expr2<\/em>)<\/h2>\n
DATE \ub610\ub294 DATETIME \ud615\uc2dd\uc758 DATETIME_expr1<\/em>,DATETIME_expr2<\/em> \uc0ac\uc774\uc758 \uaca9\ucc28\ub97c \uc815\uc218\uac12\uc73c\ub85c \ubc18\ud658\ud55c\ub2e4. \uacb0\uacfc\uac12\uc758 \ub2e8\uc704\ub294 interval<\/em> \uc778\uc790\uc5d0 \uc758\ud574 \uc8fc\uc5b4\uc9c4\ub2e4. interval<\/em> \uc758 \ud5c8\uc6a9\uac12\uc740 TIMESTAMPADD() \ud568\uc218\uc640 \uac19\ub2e4.<\/p>\n
mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');\r\n        -> 3\r\nmysql> SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01');\r\n        -> -1\r\n<\/pre>\n
TIMESTAMPDIFF()\ub294 MySQL 5.0.0 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
TIME_FORMAT(time<\/em>,format<\/em>)<\/h2>\n
\uc774 \ud568\uc218\ub294 DATE_FORMAT() \ud568\uc218\ucc98\ub7fc \uc0ac\uc6a9\ub418\uc9c0\ub9cc, format<\/em> \ubb38\uc790\uc5f4\uc740 \uc2dc, \ubd84, \ucd08\uc5d0 \uad00\ub828\ub41c \uc9c0\uc815\uc790\ub9cc\uc744 \ud3ec\ud568\ud560 \uc218 \uc788\ub2e4. \ub2e4\ub978 \uc9c0\uc815\uc790\ub4e4\uc740 NULL \uac12\uc774\ub098 ‘0’\uc744 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n
time<\/em> \uac12\uc774 TIME \ubd80\ubd84\uc5d0\uc11c 23\ubcf4\ub2e4 \ud070 \uac12\uc744 \uac16\ub294\ub2e4\uba74, %H\uc640 %k \uc2dc\uac04 \uc9c0\uc815\uc790\ub294 \uc77c\uc0c1\uc801\uc778 \ubc94\uc704 0-23\ubcf4\ub2e4 \ub354 \ud070 \uac12\uc744 \ubc1c\uc0dd\ud55c\ub2e4. \ub2e4\ub978 \uc2dc\uac04 \uc9c0\uc815\uc790\ub4e4\uc740 12 \ubc95(modulo)\uc758 \uac12\uc744 \ubc1c\uc0dd\ud55c\ub2e4.<\/p>\n
mysql> SELECT TIME_FORMAT('100:00:00', '%H %k %h %I %l');\r\n        -> '100 100 04 04 4'\r\n<\/pre>\n
TIME_TO_SEC(time<\/em>)<\/h2>\n
time<\/em> \uc778\uc790\ub97c \ucd08\ub85c \ubcc0\ud658\ud558\uc5ec \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT TIME_TO_SEC('22:23:00');\r\n        -> 80580\r\nmysql> SELECT TIME_TO_SEC('00:39:38');\r\n        -> 2378\r\n<\/pre>\n
TO_DAYS(date<\/em>)<\/h2>\n
\ub0a0\uc9dc date<\/em> \uac00 \uc8fc\uc5b4\uc9c0\uba74, \uc77c\uc218\ub97c \ubc18\ud658\ud55c\ub2e4. (0\ub144\ubd80\ud130\uc758 \uc77c\uc218).<\/p>\n
mysql> SELECT TO_DAYS(950501);\r\n        -> 728779\r\nmysql> SELECT TO_DAYS('1997-10-07');\r\n        -> 729669\r\n<\/pre>\n
TO_DAYS()\ub294 \uadf8\ub808\uace0\ub9ac\uc548 \ub2ec\ub825\uc758 \ucd9c\ud604(1582\ub144) \uc774\uc804\uc758 \uac12\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub3c4\ub85d \uacc4\ud68d\ub418\uc9c0 \uc54a\uc558\ub2e4. \ub2ec\ub825\uc774 \ubc14\ub00c\uc5c8\uc744 \ub54c \uc190\uc2e4\ub41c \ub0a0\uc9dc\ub294 \uace0\ub824\ud558\uc9c0 \uc54a\ub294\ub2e4.<\/p>\n
MySQL\ub294 \ub0a0\uc9dc\uc5d0 \uc788\ub294 2\uc790\ub9ac \ud615\uc2dd\uc758 \uc5f0\ub3c4\ub97c 4\uc790\ub9ac \ud615\uc2dd\uc73c\ub85c \ubcc0\ud658\ud55c\ub2e4\ub294 \uac83\uc744 \uae30\uc5b5\ud558\ub77c. \uc608\ub97c \ub4e4\uc5b4, ‘1997-10-07’\uacfc ’97-10-07’\ub294 \ub3d9\uc77c\ud55c \ub0a0\uc9dc\ub85c \uac04\uc8fc\ud55c\ub2e4.<\/p>\n
mysql> SELECT TO_DAYS('1997-10-07'), TO_DAYS('97-10-07');\r\n        -> 729669, 729669\r\n<\/pre>\n
1582\ub144 \uc774\uc804\uc758 \ub2e4\ub978 \ub0a0\uc9dc\uc5d0 \ub300\ud574\uc11c\ub294 \uc774 \ud568\uc218\ub294 \uacb0\uacfc\uac12\uc774 \uc815\uc758\ub418\uc9c0 \uc54a\uc558\ub2e4.<\/p>\n
UNIX_TIMESTAMP() , UNIX_TIMESTAMP(date<\/em>)<\/h2>\n
\uc778\uc790 \uc5c6\uc774 \ud638\ucd9c\uc774 \ub41c\ub2e4\uba74, \ubd80\ud638\uc5c6\ub294 \uc815\uc218\uc758 \uc720\ub2c9\uc2a4 \uc2dc\uac04(‘1970-01-01 00:00:00’ GMT\ubd80\ud130 \uacc4\uc0b0\ub41c \ucd08)\uc744 \ubc18\ud658\ud55c\ub2e4. UNIX_TIMESTAMP()\uac00 date<\/em> \uc778\uc790\uc640 \ud568\uaed8 \ud638\ucd9c\ub41c\ub2e4\uba74, ‘1970-01-01 00:00:00’ GMT\ubd80\ud130 \uacc4\uc0b0\ub41c \ucd08 \uac12\uc744 \ubc18\ud55c\ub2e4. date<\/em> \ub294 DATE \ubb38\uc790\uc5f4, DATETIME \ubb38\uc790\uc5f4, TIMESTAMP \ubb38\uc790\uc5f4, YYMMDD \ub610\ub294 YYYYMMDD \ud615\uc2dd\uc758 \uc22b\uc790\ub97c \ud5c8\uc6a9\ud55c\ub2e4.<\/p>\n
mysql> SELECT UNIX_TIMESTAMP();\r\n        -> 882226357\r\nmysql> SELECT UNIX_TIMESTAMP('1997-10-04 22:23:00');\r\n        -> 875996580\r\n<\/pre>\n
UNIX_TIMESTAMP\uac00 TIMESTAMP \ud615\uc2dd\uc73c\ub85c \uc0ac\uc6a9\ub418\uc5c8\uc744 \ub54c \uc774 \ud568\uc218\ub294 \ub0b4\ubd80\uc758 TIMESTAMP \uac12\uc744 \uc9c1\uc811 \ubc18\ud658\ud55c\ub2e4. \ubb34\uc870\uac74 \ubb38\uc790\uc5f4\uc744 \uc720\ub2c9\uc2a4 \uc2dc\uac04\uc73c\ub85c \ubcc0\ud658\ud558\uc9c0 \uc54a\ub294\ub2e4. UNIX_TIMESTAMP()\uc5d0 \ubc94\uc704\uc5d0\uc11c \ubc97\uc5b4\ub09c \ub0a0\uc9dc\ub97c \uc785\ub825\ud588\ub2e4\uba74 0\uc774 \ubc18\ud658\ub418\uc9c0\ub9cc, \uae30\ubcf8\uc801\uc778 \ubc94\uc704\ub9cc \ud655\uc778\ub41c\ub2e4\ub294 \uac83\uc5d0 \uc8fc\uc758\ud558\ub77c. (\uc5f0\ub3c4\ub2941970-2037, \uc6d4 01-12, \uc77c 01-31)<\/p>\n
UTC_DATE , UTC_DATE()<\/h2>\n
\ud568\uc218\uac00 \uc0ac\uc6a9\ub41c \ubb38\ub9e5\uc5d0 \ub530\ub77c ‘YYYY-MM-DD’ \ub610\ub294 YYYYMMDD \ud615\uc2dd\uc73c\ub85c \ud604\uc7ac\uc758 UTC \ub0a0\uc9dc \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT UTC_DATE(), UTC_DATE() + 0;\r\n        -> '2003-08-14', 20030814\r\n<\/pre>\n
UTC_DATE()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
UTC_TIME , UTC_TIME()<\/h2>\n
\ud568\uc218\uac00 \uc0ac\uc6a9\ub41c \ubb38\ub9e5\uc5d0 \ub530\ub77c ‘HH:MM:SS’ \ub610\ub294 HHMMSS \ud615\uc2dd\uc73c\ub85c \ud604\uc7ac\uc758 UTC \uc2dc\uac04 \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT UTC_TIME(), UTC_TIME() + 0;\r\n        -> '18:07:53', 180753\r\n<\/pre>\n
UTC_TIME()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
UTC_TIMESTAMP , UTC_TIMESTAMP()<\/h2>\n
\ud568\uc218\uac00 \uc0ac\uc6a9\ub41c \ubb38\ub9e5\uc5d0 \ub530\ub77c ‘YYYY-MM-DD HH:MM:SS’ \ub610\ub294 YYYYMMDDHHMMSS \ud615\uc2dd\uc73c\ub85c \ud604\uc7ac\uc758 UTC \uc77c\uc2dc \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT UTC_TIMESTAMP(), UTC_TIMESTAMP() + 0;\r\n        -> '2003-08-14 18:08:04', 20030814180804\r\n<\/pre>\n
UTC_TIMESTAMP()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
WEEK(date<\/em>[,mode<\/em>])<\/h2>\n
date<\/em> \uc5d0 \ub300\ud558\uc5ec \uba87\ubc88\uc9f8 \uc8fc\uc778\uc9c0 \ubc18\ud658\ud55c\ub2e4. 2\uac1c \uc778\uc790\ub97c \uc0ac\uc6a9\ud558\ub294 \ud615\uc2dd\uc5d0\uc11c\ub294, \ud55c \uc8fc\uc758 \uc2dc\uc791\uc744 \uc77c\uc694\uc77c\ub85c \ud560 \uac83\uc778\uc9c0 \uc6d4\uc694\uc77c\ub85c \ud560 \uac83\uc778\uc9c0, \uacb0\uacfc\uac12\uc758 \ubc94\uc704\ub97c 0-53\uc73c\ub85c \ud560 \uac83\uc778\uc9c0 1-53\uc73c\ub85c \ud560 \uac83\uc778\uc9c0\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. mode<\/em> \uc778\uc790\uac00 \uc0dd\ub7b5\ub418\uba74 \uc2dc\uc2a4\ud15c \uae30\ubcf8\uac12\uc774 \uc0ac\uc6a9\ub41c\ub2e4. (MySQL 4.0.14 \ubc84\uc804 \uc774\uc804\uc5d0\ub294 0)<\/p>\n
mode<\/em> \uc778\uc790\ub294 \uc544\ub798 \ud45c\uc640 \uac19\uc774 \uc791\ub3d9\ud55c\ub2e4.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
\ubaa8\ub4dc<\/th>\n\ud55c \uc8fc\uc758 \uc2dc\uc791\uc694\uc77c<\/th>\n\ubc94\uc704<\/th>\nWeek 1 is the first week…<\/th>\n<\/tr>\n
0<\/td>\nSunday<\/td>\n0-53<\/td>\nwith a Sunday in this year<\/td>\n<\/tr>\n
1<\/td>\nMonday<\/td>\n0-53<\/td>\nwith more than 3 days this year<\/td>\n<\/tr>\n
2<\/td>\nSunday<\/td>\n1-53<\/td>\nwith a Sunday in this year<\/td>\n<\/tr>\n
3<\/td>\nMonday<\/td>\n1-53<\/td>\nwith more than 3 days this year<\/td>\n<\/tr>\n
4<\/td>\nSunday<\/td>\n0-53<\/td>\nwith more than 3 days this year<\/td>\n<\/tr>\n
5<\/td>\nMonday<\/td>\n0-53<\/td>\nwith a Monday in this year<\/td>\n<\/tr>\n
6<\/td>\nSunday<\/td>\n1-53<\/td>\nwith more than 3 days this year<\/td>\n<\/tr>\n
7<\/td>\nMonday<\/td>\n1-53<\/td>\nwith a Monday in this year<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
mode<\/em> 3\uc740 MySQL 4.0.5 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\uc73c\uba70, 4 \uc774\uc0c1\uc758 mode<\/em> \ub294 MySQL 4.0.17 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub2e4.<\/p>\n
mysql> SELECT WEEK('1998-02-20');\r\n        -> 7\r\nmysql> SELECT WEEK('1998-02-20',0);\r\n        -> 7\r\nmysql> SELECT WEEK('1998-02-20',1);\r\n        -> 8\r\nmysql> SELECT WEEK('1998-12-31',1);\r\n        -> 53\r\n<\/pre>\n
\uc8fc\uc758 : MySQL 4.0 \ubc84\uc804\uc5d0\uc11c WEEK(date<\/em>,0)\ub294 \ubbf8\uad6d \ub2ec\ub825\uc5d0 \uc54c\ub9de\uac8c \ubcc0\ud588\ub2e4. \uadf8 \uc804\uc5d0 WEEK()\ub294 \ubbf8\uad6d \ub0a0\uc9dc\uc5d0\uc11c \uc798\ubabb \uacc4\uc0b0\ub418\uc5c8\ub2e4. (\uc0ac\uc2e4\uc0c1 WEEK(date<\/em>)\uc640 WEEK(date<\/em>,0)\ub294 \ubaa8\ub4e0 \uacbd\uc6b0\uc5d0 \uc624\ub958\uac00 \uc788\uc5c8\ub2e4.)<\/p>\n
\uc774\uc804 \uc5f0\ub3c4\uc758 \ub9c8\uc9c0\ub9c9\uc8fc\uc5d0\uc11c \ub0a0\uc9dc\uac00 \ub9de\uc544\ub5a8\uc5b4\uc9c0\uba74, mode<\/em> \uc778\uc790\ub97c 2, 3, 6, 7 \uc73c\ub85c \uc120\ud0dd\ud558\uc9c0 \uc54a\ub294 \ud55c MySQL\uc740 0\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT YEAR('2000-01-01'), WEEK('2000-01-01',0);\r\n        -> 2000, 0\r\n<\/pre>\n
\uc5b4\ub5a4 \uc774\ub294 \uc2e4\uc81c\ub85c \uc8fc\uc5b4\uc9c4 \ub0a0\uc9dc\uac00 1999\ub144\uc758 52\uc9f8\uc8fc\uc774\uae30 \ub54c\ubb38\uc5d0 WEEK() \ud568\uc218\uac00 52\ub97c \ubc18\ud658\ud574\uc57c \ud55c\ub2e4\uace0 \uc8fc\uc7a5\ud55c\ub2e4. \uc6b0\ub9ac\ub294 \uc8fc\uc5b4\uc9c4 \uc5f0\ub3c4\uc5d0\uc11c \uba87 \uc9f8\uc8fc\uc778\uc9c0 \ubc18\ud658\ud560 \uac83\uc744 \uc6d0\ud588\uae30 \ub54c\ubb38\uc5d0 \uadf8 \ub300\uc2e0 0\uc744 \ubc18\ud658\ud558\uae30\ub85c \ud588\ub2e4. \uc774\uac83\uc740 WEEK() \ud568\uc218\ub97c \ub0a0\uc9dc\uc5d0\uc11c DATE \ubd80\ubd84\uc744 \ucd94\ucd9c\ud558\ub294 \ub2e4\ub978 \ud568\uc218\ub4e4\uacfc \uacb0\ud569\ud558\uc5ec \uc0ac\uc6a9\ud560 \ub54c \uc720\uc6a9\ud558\ub2e4.<\/p>\n
\uc8fc\uc5b4\uc9c4 \ub0a0\uc9dc\uc758 \uc8fc\uac04 \uccab\ub0a0\uc744 \ud3ec\ud568\ud55c \ud574\ub97c \uace0\ub824\ud55c \uacb0\uacfc\uac12\uc744 \uc6d0\ud55c\ub2e4\uba74, mode<\/em> \uc778\uc790\ub97c 0, 2, 5, 7 \ub85c \uc120\ud0dd\ud574\uc57c \ud55c\ub2e4.<\/p>\n
mysql> SELECT WEEK('2000-01-01',2);\r\n        -> 52\r\n<\/pre>\n
YEARWEEK() \ud568\uc218\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\ub3c4 \ub300\uc548\uc774 \ub420 \uc218 \uc788\ub2e4.<\/p>\n
mysql> SELECT YEARWEEK('2000-01-01');\r\n        -> 199952\r\nmysql> SELECT MID(YEARWEEK('2000-01-01'),5,2);\r\n        -> '52'\r\n<\/pre>\n
WEEKDAY(date<\/em>)<\/h2>\n
date<\/em> \uc5d0 \ub300\ud55c \uc694\uc77c \uc0c9\uc778\uac12(0 = \uc6d4\uc694\uc77c, 1 = \ud654\uc694\uc77c, … 6 = \uc77c\uc694\uc77c)\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
mysql> SELECT WEEKDAY('1998-02-03 22:23:00');\r\n        -> 1\r\nmysql> SELECT WEEKDAY('1997-11-05');\r\n        -> 2\r\n<\/pre>\n
WEEKOFYEAR(date<\/em>)<\/h2>\n
date<\/em> \uc758 \ub2ec\ub825\uc5d0\uc11c \uba87 \uc8fc\uc9f8\uc778\uc9c0 1-53 \ubc94\uc704\uc758 \uac12\uc744 \ubc18\ud658\ud55c\ub2e4. \uc774 \ud568\uc218\ub294 WEEK(date<\/em>,3)\uacfc \ub3d9\uc77c\ud558\ub2e4.<\/p>\n
mysql> SELECT WEEKOFYEAR('1998-02-20');\r\n        -> 8\r\n<\/pre>\n
WEEKOFYEAR()\ub294 MySQL 4.1.1 \ubc84\uc804\ubd80\ud130 \uc0ac\uc6a9\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
YEAR(date<\/em>)<\/h2>\n
date<\/em> \uc5d0\uc11c \ud574\ub2f9 \uc5f0\ub3c4\ub97c \ubc18\ud658\ud55c\ub2e4. (\ubc94\uc704 1000-9999)<\/p>\n
mysql> SELECT YEAR('98-02-03');\r\n        -> 1998\r\n<\/pre>\n
YEARWEEK(date<\/em>) , YEARWEEK(date<\/em>,start<\/em>)<\/h2>\n
date<\/em> \uc5d0 \ub300\ud558\uc5ec \uc5f0\ub3c4\uc640 \uba87 \uc8fc\uc9f8\uc778\uc9c0 \ubc18\ud658\ud55c\ub2e4. \uccab\ubc88\uc9f8 \uc778\uc790\ub294 WEEK()\uc758 \uccab\ubc88\uc9f8 \uc778\uc790\uc640 \uc815\ud655\ud558\uac8c \uc791\ub3d9\ud55c\ub2e4. \uacb0\uacfc \uc548\uc758 \uc5f0\ub3c4\ub294 \uccab \uc8fc\uc640 \ub9c8\uc9c0\ub9c9 \uc8fc\uc5d0 \ud55c\ud558\uc5ec date<\/em> \uc778\uc790\uc758 \uc5f0\ub3c4\uc640 \ub2e4\ub97c \uc218 \uc788\ub2e4.<\/p>\n
mysql> SELECT YEARWEEK('1987-01-01');\r\n        -> 198653\r\n<\/pre>\n
\uc8fc\uc218\ub294 \uc120\ud0dd \uc778\uc790 0 \ub610\ub294 1 \uc5d0 \ub300\ud558\uc5ec WEEK() \ud568\uc218\uac00 \ubc18\ud658\ud558\ub294 \uac83\uacfc \ub2e4\ub974\ub2e4. WEEK()\ub294 \uc8fc\uc5b4\uc9c4 \uc5f0\ub3c4\uc758 \ubb38\ub9e5\uc5d0\uc11c \uc8fc \uac12\uc744 \ubc18\ud658\ud55c\ub2e4.<\/p>\n
YEARWEEK()\ub294 MySQL 3.23.8 \ubc84\uc804\uc5d0\uc11c \ucd94\uac00\ub418\uc5c8\ub2e4.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"
DATE \uac12\uc744 \uae30\ub300\ud558\ub294 \ud568\uc218\ub4e4\uc740 \uc77c\ubc18\uc801\uc73c\ub85c DATETIME \uac12\uc744 \uc218\uc6a9\ud558\uace0, TIME \ubd80\ubd84\uc740 \ubb34\uc2dc\ud55c\ub2e4. TIME \uac12\uc744 \uae30\ub300\ud558\ub294 \ud568\uc218\ub4e4\uc740 \uc77c\ubc18\uc801\uc73c\ub85c DATETIME \uac12\uc744 \uc218\uc6a9\ud558\uace0, DATE \ubd80\ubd84\uc740 \ubb34\uc2dc\ud55c\ub2e4. \ud604\uc7ac \ub0a0\uc9dc\ub098 \uc2dc\uac04\uc744 \ubc18\ud658(return)\ud558\ub294 \ud568\uc218\ub4e4\uc740 \ucffc\ub9ac\uac00 \uc2e4\ud589\ub420 \ub54c \ub2e8 \ud55c\ubc88\ub9cc \uadf8 \uac12\uc744 \uad6c\ud55c\ub2e4. \uc774\uac83\uc740 \ud55c \ucffc\ub9ac \uc548\uc5d0 NOW()\uc640 \uac19\uc740 \ud568\uc218\uac00 \uc5ec\ub7ec\ubc88 \uc0ac\uc6a9\ub418\uc5c8\uc744 \uacbd\uc6b0\uc5d0\ub3c4 \ubaa8\ub450 \uac19\uc740 \uacb0\uacfc\uac12\uc744 \ucc38\uc870\ud55c\ub2e4\ub294 \uac83\uc744 \uc758\ubbf8\ud55c\ub2e4. \uc774 \uc6d0\uce59\uc740 CURDATE(), CURTIME(), … <\/p>\n
\ub354 \ubcf4\uae30 “mariadb(mysql) \ub0a0\uc9dc\uc640 \uc2dc\uac04 \ud568\uc218 – \ud38c”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[109,106,105,107,108],"_links":{"self":[{"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/175"}],"collection":[{"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=175"}],"version-history":[{"count":1,"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/175\/revisions"}],"predecessor-version":[{"id":176,"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/175\/revisions\/176"}],"wp:attachment":[{"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=175"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/poteto.co.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}