Postgres Pro
Downloads
Home   >   mailing lists

timestamp check - Mailing list pgsql-general

From Ramesh T
Subject timestamp check
Date
Msg-id CAK8Zd=tykggSxXhvG+oRJ8KQ8rn17G7FcGjHFA47bt0p+eRGnQ@mail.gmail.com
Whole thread Raw
Responses Re: timestamp check
Re: timestamp check
Re: timestamp check
Re: timestamp check
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: "Charles Clavadetscher"
Date:
Subject: Re: Row level security - notes and questions
Next
From: Ramesh T
Date:
Subject: xmltable in postgres like in oracle..?