Timestamp and Extract

시스템 설정 값 보기

show all  -- 전체 설정값 보기
show TIMEZONE -- Asia/Seoul

 

date, time 관련 질의

select now() -- 2023-07-28 17:04:20.123 +0900
select current_time  -- 17:05:06 +0900
select current_date -- 2023-07-28
select current_timestamp -- 2023-07-28 17:05:27.491 +0900

 

extract 

https://www.postgresql.org/docs/12/functions-formatting.html 에서 상세한 날짜/시간 포맷을 확인할 수 있다.

select extract(year from payment_date) as my_year from payment  -- 2022
select extract(quarter from payment_date) as my_year from payment -- 2
select to_char(payment_date, 'YYYY-MM-DD HH24:MI:SS.MS') from payment  -- 2007-02-15 22:25:46.996