TZ_OFFSET

Started by Ramesh Tover 11 years ago2 messagesgeneral

rameshparnanditech@gmail.com

over 11 years ago

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

vyegorov@gmail.com

over 11 years ago

In reply to: Ramesh T (#1)

Re: TZ_OFFSET

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