Re: timestamp check

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..

[image: Inline image 1]

But in oracle using systimestamp,to_timestamptz and SS TZH is not
supporting to_timestamp in postgres.

result..

[image: Inline image 2]

diffrence is days displaying in postgres query..i thnk something wrong. is
it..?

any help apprictiated.

On Sat, Jul 11, 2015 at 11:12 PM, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 07/10/2015 05:54 AM, Ramesh T wrote:
>
>>
>> select current_timestamp-to_timestamp(to_char(current_date,'YYYY-MM-DD
>> HH24'||':'||'MI'||':'||'SS')||' '||(SELECT utc_offset FROM
>> pg_catalog.pg_timezone_names
>> WHERE name='US/Eastern'),'YYYY-MM-DD
>> HH24'||':'||'MI'||':'||'SS')::timestamptz;
>>
>> it's not displaying timezone..any help..?
>>
>>
> Forget my previous post, Rays post made me realize the error of my ways,
> namely thinking current_timestamp-to_timestamp was a function.
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>