select
group_concat(출력하고자하는컬럼명 separator '여기안에 구분자')
from
sample
group_concat(출력하고자하는컬럼명 separator '여기안에 구분자')
from
sample
SELECT DATE_ADD(LAST_day(DATE_ADD(CURDATE(), INTERVAL -2 month)),interval +1 day) FROM DUAL ;
SELECT CAST(DATE_FORMAT(DATE_ADD(CURDATE(), INTERVAL -1 month),'%Y%m') AS CHAR(6)) FROM DUAL;
select NOW() - INTERVAL 365*15 DAY,
NOW() - INTERVAL 365*15-7 DAY,
NOW() - INTERVAL 7 DAY
FROM DUAL;
