mysql function

# DATE => String
DATE_FORMAT(SVC_END_YMD,'%Y-%m-%d %H:%i:%s')

# String => Date
mysql> SELECT STR_TO_DATE('01,5,2013','%d,%m,%Y');
        -> '2013-05-01'


# DATE 증감
ADDDATE(NOW(),-1)


# 타입 변환

CONVERT(expr,type), CONVERT(expr USING transcoding_name)

The CONVERT() and CAST() functions take a value of one type and produce a value of another type.

The type can be one of the following values:

• BINARY[(N)]

• CHAR[(N)]

• DATE

• DATETIME

• DECIMAL[(M[,D])]

• SIGNED [INTEGER]

• TIME

• UNSIGNED [INTEGER]

 

# NULL 체킹

mysql> SELECT IFNULL(NULL,10);
        -> 10