SQL / 현재로부터 n시간 전후 구하기

 

 

SELECT Now(),
       Now() + interval '1YEAR'    as year , -- 1년 뒤
       now() + interval '1MONTH'   AS month , -- 1달 뒤
       now() + interval '1DAY'     AS day , -- 1일 뒤
       now() + interval '1HOUR'    AS hour , -- 1시간 뒤
       now() + interval '1MINUTES' AS minute , -- 1분 뒤
       now() + interval '1SECOND'  AS sceond; -- 1초 뒤

---

SELECT Now(),
       Now() - interval '1YEAR'    as year , -- 1년 전
       now() - interval '1MONTH'   AS month , -- 1달 전
       now() - interval '1DAY'     AS day , -- 1일 전
       now() - interval '1HOUR'    AS hour , -- 1시간 전
       now() - interval '1MINUTES' AS minute , -- 1분 전
       now() - interval '1SECOND'  AS sceond; -- 1초 전