subject:"\[GENERAL\] TZ_OFFSET"

Re: [GENERAL] TZ_OFFSET

2014-07-29 Thread Victor Yegorov

2014-07-28 13:19 GMT+03:00 Ramesh T : > 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

[GENERAL] TZ_OFFSET

2014-07-29 Thread 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