Postgres Pro
Downloads
Home   >   mailing lists

TZ_OFFSET - Mailing list pgsql-general

From Ramesh T
Subject TZ_OFFSET
Date
Msg-id CAK8Zd=tSc71rRQm=Z=q_7qNMKJ_CqVLfSwO8pZbiQTZkoR1=Bw@mail.gmail.com
Whole thread Raw
Responses Re: TZ_OFFSET  (Victor Yegorov <vyegorov@gmail.com>)
List pgsql-general
Tree view
Hello,

             select TZ_OFFSET ('US/Eastern') from dual ;

it's returning in oracle
----------------------------------
-04:00


but in postgres

select TZ_OFFSET ('US/Eastern');

its'returning like function tz_offset('us/Eastern') does not exist;
let me know how to solve issue

pgsql-general by date:

Previous
From: "byfei163@163.com"
Date:
Subject: Re: PG_TERMINATE_BACKEND not working.
Next
From: Victor Yegorov
Date:
Subject: Re: TZ_OFFSET