Tatsuo Ishii wrote:
> Hi,
> test=# select t at time zone 'jst' from t2;
> timezone
> -------------
> 17:34:56+09
> (1 row)
>
> test=# select t::time from t2;
> t
> ----------
> 12:34:56
> (1 row)
Hello,
timezone_test=# select cast(t as time with time zone) from t2;
t
-------------
12:34:56+04
(1 row)
?
Sincerely,
Joshua D. Drake