time zone 변환 |
글쓴이 : PostgresDBA
날짜 : 2018-10-30 (화) 09:34
조회 : 8207
|
|
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
|
time zone 변환 > SQL
 |
|||
 |
PostgreSQL 은 특별합니다.
단순한 데이터베이스가 아니라, 하나의 어플리케이션 플랫폼이기 때문입니다. |
||
 |
|
