Postgres Pro
Downloads
Home   >   mailing lists

Thread: TZ_OFFSET

TZ_OFFSET

From
Ramesh T
Date:
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

Re: TZ_OFFSET

From
Victor Yegorov
Date:
2014-07-28 13:19 GMT+03:00 Ramesh T <rameshparnanditech@gmail.com>:
select TZ_OFFSET ('US/Eastern');

its'returning like function tz_offset('us/Eastern') does not exist;

SELECT *
  FROM pg_catalog.pg_timezone_names
 WHERE name='US/Eastern';


--
Victor Y. Yegorov