[PostgreSQL] 날짜/시간

-- 날짜 시간 타입으로 캐스팅 

select '20190320'::date, '2019-01-02'::date

select date '2019-03-18'

select to_date('01022019','MMDDYYYY'), to_date('2018-12-25', 'YYYY-MM-DD')

select to_timestamp('2019-01-01 20:12:12', 'YYYY-MM-DD HH:MI:SS')

 

-- 현재시간 날짜 구하기 

select now(), current_date, current_time 

 

-- 시간 더하고 빼기 

select '2019-01-01'::date + interval '2 sec', '2019-01-01'::date - interval '2 sec'

select '2019-01-01'::date + interval '2 min', '2019-01-01'::date - interval '2 min'

select '2019-01-01'::date + interval '2 hour', '2019-01-01'::date - interval '2 hour'

select '2019-01-01'::date + interval '2 day', '2019-01-01'::date - interval '2 day'

select '2019-01-01'::date + interval '2 week', '2019-01-01'::date - interval '2 week'

select '2019-01-01'::date + interval '2 month', '2019-01-01'::date - interval '2 month'

select '2019-01-01'::date + interval '2 year', '2019-01-01'::date - interval '2 year'

select ('2019-01-01'::date + interval '2 day') + interval '2 hour'

select now() + (600 * interval '1 sec'), now() + interval '600 sec'

select now(), now() + interval '15h 2m 12s'

 

-- day of year 구하기 

select extract(doy from now())

 

-- 시간파트 구하기 

select to_char(now(), 'YYYY-MM-DD HH24:MI:SS')

select to_char(now(), 'MONTH:Month:month:MON:Mon:mon:WW:W:D')

 

https://walkingfox.tistory.com/90  

postgreSQL 날짜/시간 함수

https://youngwonhan-family.tistory.com/entry/PostgreSQL-%EB%82%A0%EC%A7%9C-API-%EB%8B%A4%EB%A3%A8%EA%B8%B0-%EB%91%90-%EB%82%A0%EC%A7%9C-%EC%82%AC%EC%9D%B4-%EC%8B%9C%EA%B0%84-%EA%B3%84%EC%82%B0-extract-age-%EB%93%B1

PostgreSQL 날짜 API 다루기( 두 날짜 사이 시간 계산, extract, age 등 )

https://sas-study.tistory.com/389

[Postgresql] 날짜시간 함수, date_part() 사용법 정리