Quick Links

timestamp check

From:	Ramesh T <rameshparnanditech(at)gmail(dot)com>
To:	"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	timestamp check
Date:	2015-07-10 12:54:02
Message-ID:	CAK8Zd=tykggSxXhvG+oRJ8KQ8rn17G7FcGjHFA47bt0p+eRGnQ@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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

Responses

Re: timestamp check at 2015-07-11 16:04:47 from David G. Johnston
Re: timestamp check at 2015-07-11 17:30:22 from Adrian Klaver
Re: timestamp check at 2015-07-11 17:34:07 from Raymond O'Donnell
Re: timestamp check at 2015-07-11 17:42:27 from Adrian Klaver

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2015-07-10 14:03:46	Re: How to test SSL cert from CA?
Previous Message	Francisco Reyes	2015-07-10 04:29:38	Re: How to test SSL cert from CA?