| From: | cat(at)zip(dot)com(dot)au |
|---|---|
| To: | Shilpa Sudhakar <ssudhakar(at)internode(dot)com(dot)au> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Time Zone in Postgres |
| Date: | 2008-03-06 23:46:53 |
| Message-ID: | 20080306234653.GA20591@bunyip.billabong.weebeasite.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shilpa Sudhakar | 2008-03-07 00:18:22 | Re: Time Zone in Postgres |
| Previous Message | Shilpa Sudhakar | 2008-03-06 22:56:51 | Re: Time Zone in Postgres |