> 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