From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "soni de" <soni(dot)de(at)gmail(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Regarding Timezone |
Date: | 2007-06-19 16:20:10 |
Message-ID: | 504.1182270010@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
"soni de" <soni(dot)de(at)gmail(dot)com> writes:
> But we want to set this timezone parameter to IST.
Which "IST" are you interested in? Irish, Israel, or Indian Standard Time?
Postgres prefers to use the zic timezone names, which are less
ambiguous. Try this to see likely options:
regression=# select * from pg_timezone_names where abbrev = 'IST';
name | abbrev | utc_offset | is_dst
---------------+--------+------------+--------
Asia/Calcutta | IST | 05:30:00 | f
Asia/Colombo | IST | 05:30:00 | f
Europe/Dublin | IST | 01:00:00 | t
Eire | IST | 01:00:00 | t
(4 rows)
If you're after Indian Standard Time, set timezone to 'Asia/Calcutta'.
You'll probably also want to set timezone_abbreviations to 'India' so
that "IST" is interpreted the way you want in timestamp datatype input.
See
http://www.postgresql.org/docs/8.2/static/datetime-config-files.html
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Campbell, Lance | 2007-06-19 16:23:50 | PostgreSQL Configuration Tool for Dummies |
Previous Message | Gregory Stark | 2007-06-19 16:12:05 | Re: Performance query about large tables, lots of concurrent access |