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
