Home > mailing lists

Re: TZ_OFFSET - Mailing list pgsql-general

From	Victor Yegorov
Subject	Re: TZ_OFFSET
Date	July 29, 2014 21:58:03
Msg-id	CAGnEbog_Y5hYr__AFWDbyJEeW-irymxXz_K_WFyNFsRAtQjH1w@mail.gmail.com Whole thread Raw
In response to	TZ_OFFSET (Ramesh T <rameshparnanditech@gmail.com>)
List	pgsql-general

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

From: Ramesh T
Date: 29 July 2014, 21:39:51
Subject: TZ_OFFSET

From: gajendra s v
Date: 29 July 2014, 22:50:14
Subject: Is there any way to recover updated values from the table(Need old value)