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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
