beta_jgw=# update scenario1.time_test set local_hour = extract(hour from to_timestamp(to_char(gmt_date,'YYYY-MM-DD')||'
'||to_char(gmt_hour,'99')||':00:00-00','YYYY-MM-DD HH24:MI:SS') at time
zone 'EST'); ^^^^^^^^
This sounds like a stupid answer, but shouldn't that be :00:00:00?
Regards, Yasir
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
