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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
