TZ_OFFSET

From: Ramesh T <rameshparnanditech(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: TZ_OFFSET
Date: 2014-07-28 10:19:35
Message-ID: CAK8Zd=tSc71rRQm=Z=q_7qNMKJ_CqVLfSwO8pZbiQTZkoR1=Bw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2014-07-28 13:18:09 Re: [GENERAL] pg_dump behaves differently for different archive formats
Previous Message Craig Ringer 2014-07-28 03:15:51 Re: hstore/jsonb support in hibernate/JPA