Re: timestamp with time zone - Mailing list pgsql-general

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