Re: timestamp check

On 11/07/2015 17:11, Ramesh T wrote:
> okay,i'm executing a query from pgadmin3.
>
> i want display time with timezone.But above query  displaying date and
> time not timezone...
>
> On Sat, Jul 11, 2015 at 9:34 PM, David G. Johnston
> <david.g.johnston@gmail.com <mailto:david.g.johnston@gmail.com>> wrote:
>
>     On Fri, Jul 10, 2015 at 8:54 AM, Ramesh T
>     <rameshparnanditech@gmail.com
>     <mailto:rameshparnanditech@gmail.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..?

Hi there,

This question was answered a few days ago, but perhaps you didn't see
it. The reason you don't get timezone information is that subtracting
two timestamps results in an interval value. See table 9-27 on this page:

  http://www.postgresql.org/docs/9.4/static/functions-datetime.html

Also, please don't top-post; the convention on this list is to
bottom-post. Thanks! :-)

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie