On Fri, Mar 07, 2008 at 09:26:51AM +1030, Shilpa Sudhakar wrote:
> Hi Tom,
>
> We have different databases with different versions.
>
> I checked the database with *version 8.2.4* by running the below query
>
> echo select timestamp with time zone \'epoch\' + 1206970200 \* INTERVAL
> \'1 second\'\; | psql template1
> ?column?
> ---------------------------
> 2008-03-31 23:00:00+09:30
> (1 row)
>
> This shows the wrong date. The actual result should be *2008-04-01
> 00:00:00+10:30 *
I believe postgres comes with its own timezone info. Check if the stuff
it has has the right timezone information. Personally I get it to use
the system timezone definitions so that I can keep things upto-date
easier.
--
CaT