Re: timestamp check - Mailing list pgsql-general

From Adrian Klaver
Subject Re: timestamp check
Date
Msg-id 55A3C5BC.2090905@aklaver.com
Whole thread Raw
In response to Re: timestamp check  (Ramesh T <rameshparnanditech@gmail.com>)
List pgsql-general
On 07/11/2015 11:21 PM, Ramesh T wrote:
> 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..

First there is no indication of what DATE1 and DATETIMEZOZE1 are, so the
result you show has no context.

Second why are you doing all this? You are taking a timestamp (I
presume) converting it to a string and then converting it back to a
timestamp, just to to timestamp subtraction.

 From what I can piece together you seem to be wanting to get the
interval between two timestamps, is this correct?

Is so or if not, show us a schematic representation of what you are
trying to achieve. For example:

'07/13/2015 07:03:15'::timestamp - '01/01/2015 14:15:00'::timestamp

= interval in days, hours, etc

>
> Inline image 1
>
>
> But in oracle using systimestamp,to_timestamptz and SS TZH is not
> supporting  to_timestamp in postgres.
>
> result..
>
> 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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Ramesh T
Date:
Subject: Re: xmltable in postgres like in oracle..?
Next
From: Raymond O'Donnell
Date:
Subject: Re: timestamp check