파란크리스마스

-- 지난주 월요일부터 일요일까지 select sysdate - 5 - to_char(sysdate, 'd'), sysdate + 1 - to_char(sysdate, 'd') from dual -- 이번주 월요일부터 일요일까지 select sysdate + 2 - to_char(sysdate, 'd'), sysdate + 8 - to_char(sysdate, 'd') from dual

출처 http://www.w3schools.com/sql/sql_between.asp select decode(statusid,1,1,0) as f1, decode(statusid,2,1,0) as f2, decode(statusid,3,1,0) as f3, decode(statusid,4,1,0) as f4 from jsp_board where write_date BETWEEN to_date(to_char(sysdate,'yyyymmdd') || '000000','yyyymmddhh24miss') and to_date(to_char(sysdate + 1,'yyyymmdd') || '000000','yyyymmddhh24miss')