Re: timestamp check

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ramesh T <rameshparnanditech(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: timestamp check
Date: 2015-07-11 16:04:47
Message-ID: CAKFQuwaTMxaVKjc7Jg7HW=xGSPKen9Sb34cmPiTLrLEkGkG1=Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jul 10, 2015 at 8:54 AM, Ramesh T <rameshparnanditech(at)gmail(dot)com>
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..?
>
>
​You haven't told us how you are executing the above query.

It also seems like an awfully convoluted answer to whatever query you are
asking.

David J.
​

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ramesh T 2015-07-11 16:11:49 Re: timestamp check
Previous Message Ramesh T 2015-07-11 15:32:23 xmltable in postgres like in oracle..?