create table t (n int); insert into t values (1); -- 13번 반복하면 4096행이 생성됨 insert into t select * from t SELECT * FROM t SELECT * FROM date_t create table date_t (d date, ds char(10));  insert into date_t select d, date_format(d, '%Y-%m-%d') from (   select @rnum:=@rnum+1 as rownum, date(adddate('2024-01-01', interval @rnum day)) as d   from (select @rnum:=-1) r, t   ) t where year(d)  [출처] http:/..

SELECT ym, MIN(CASE dw WHEN 1 THEN LPAD(d,2,'0') END) Sun, MIN(CASE dw WHEN 2 THEN LPAD(d,2,'0') END) Mon, MIN(CASE dw WHEN 3 THEN LPAD(d,2,'0') END) Tue, MIN(CASE dw WHEN 4 THEN LPAD(d,2,'0') END) Wed, MIN(CASE dw WHEN 5 THEN LPAD(d,2,'0') END) Thu, MIN(CASE dw WHEN 6 THEN LPAD(d,2,'0') END) Fri, MIN(CASE dw WHEN 7 THEN LPAD(d,2,'0') END) Sat FROM (SELECT date_format(dt, '%Y%m') ym, Week(dt) w,..

---- 날자 계산하기 ---- -- 오늘날자 (현재날자 0시 0분 0초 ...) SELECT to_char(trunc(sysdate,'dd') ,'yyyy/mm/dd hh24:mi:ss') FROM dual ; -- 내일날자 (다음날자 0시 0분 0초 ...) SELECT to_char(trunc(sysdate,'dd') + 1,'yyyy/mm/dd hh24:mi:ss') FROM dual ; -- 내일날자 (다음날자 현재시 현재분 현재초 ...) SELECT to_char(sysdate + 1 ,'yyyy/mm/dd hh24:mi:ss') FROM dual ; ---- 달 계산하기 ---- -- 이번달 시작날자(현재달 1일 0시 0분 0초 ...) SELECT to_char(trunc(sysdate,..

SELECT TO_CHAR(TRUNC(ADD_MONTHS(SYSDATE,-1)+1)-TO_CHAR(SYSDATE,'DD'),'YYYYMMDD')||TO_CHAR(TRUNC(LAST_DAY(ADD_MONTHS(SYSDATE, -1)))+0.99999421,'YYYYMMDD') AS "대상기간" FROM DUAL