설문조사
PostgreSQL/PPAS 관련 듣고 싶은 교육은


Powered by EnterpriseDB
총 게시물 88건, 최근 0 건
 

time zone 변환

글쓴이 : PostgresDBA 날짜 : 2018-10-30 (화) 09:34 조회 : 154
select * from pg_timezone_names;

아래 결과를 추측해보세요.

with x(t) as ( values(current_timestamp))
select
t a,
t::timestamp with time zone b,
t::timestamp without time zone c,
t  at time zone 'utc' d,
t at time zone 'asia/seoul' e,
t at time zone 'utc' at time zone 'asia/seoul' f
From x;



답은 저 아래에 ...

































-[ RECORD 1 ]--------------------
a | 2018-10-30 09:28:25.535299+09
b | 2018-10-30 09:28:25.535299+09
c | 2018-10-30 09:28:25.535299
d | 2018-10-30 00:28:25.535299
e | 2018-10-30 09:28:25.535299
f | 2018-10-30 00:28:25.535299+09


 

postgresdba.com