[MySQL]날짜관련 처리함수

날짜관련 함수 사용법

# YEAR
# %Y [2010]
# %y [10]

# MONTH
# %M [january-december]
# %b jan-dec[]
# %m [01-12]
# %c [1-12]

# DAY
# %D [1st-31th]
# %d [01-31]
# %j [001-365]

#HOUR
# %r [00:00:00-23:59:59 PM]
# %T [00:00:00-23:59:59]
#MINUTE

#SECOND
# %S [00-59]

(예문)
SELECT
now() AS 'now',
YEAR(now()) AS 'year',
MONTH(now()) AS 'month',
DAY(now()) AS 'day',
DAYOFWEEK(now()) AS 'dayofweek',
HOUR(now()) AS 'hour',
MINUTE(now()) AS 'minute',
SECOND(now()) AS 'second',
DATE_FORMAT(now(),'%Y-%m-%d')