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