postgres query
select current_timestamp-
TO_TIMESTAMP(to_char(DATE1, 'YYYY-MM-DD HH24'|| ' '||'MI'||' '||'SS')||' '||(SELECT utc_offset FROM pg_catalog.pg_timezone_names
WHERE name=DATETIMEZOZE1) , ''YYYY-MM-DD HH24'||' '||'MI'||' '||'SS')::timestamptz
getting result..
But in oracle using systimestamp,to_timestamptz and SS TZH is not supporting to_timestamp in postgres.
result..
diffrence is days displaying in postgres query..i thnk something wrong. is it..?
any help apprictiated.