Обсуждение: TZ_OFFSET

Поиск
Список
Период
Сортировка

TZ_OFFSET

От
Ramesh T
Дата:
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

От
Victor Yegorov
Дата:
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