curdate() 썸네일형 리스트형 현재 날짜 curdate() 잘르기 substring mysql> SELECT substring(CONCAT(curdate()+0,"0000"),3,10); +--------------------------------------------+ | substring(CONCAT(curdate()+0,"0000"),3,10) | +--------------------------------------------+ | 1812100000 | +--------------------------------------------+ 1 row in set (0.00 sec) 더보기 현재날짜+텍스트or숫자 출력하기 mysql> SELECT CONCAT(curdate()+0, '11'); +---------------------------+ | CONCAT(curdate()+0, '11') | +---------------------------+ | 2018121011 | +---------------------------+ 1 row in set (0.00 sec) mysql> SELECT CONCAT(curdate()+0, '숫자'); +-------------------------------+ | CONCAT(curdate()+0, '숫자') | +-------------------------------+ | 20181210숫자 | +-------------------------------+ 1 row in s.. 더보기 현재날짜 출력하기 mysql> SELECT curdate()+0; +-------------+ | curdate()+0 | +-------------+ | 20181210 | +-------------+ 1 row in set (0.00 sec) mysql> SELECT curdate();+------------+| curdate() |+------------+| 2018-12-10 |+------------+ 1 row in set (0.00 sec) 더보기 이전 1 다음