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.johns...@gmail.com> wrote: > On Fri, Jul 10, 2015 at 8:54 AM, Ramesh T <rameshparnandit...@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..? >> >> > 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. > > >
