Re: Asia/kolkatta timezone

From: "A(dot)M(dot)" <agentm(at)themactionfaction(dot)com>
To: Prasath Rajan <prasath(dot)rajan(at)sword-in(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Asia/kolkatta timezone
Date: 2011-04-15 14:25:47
Message-ID: 8E9112EC-78EC-41E6-BAFD-7122F0C7BFED@themactionfaction.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


On Apr 15, 2011, at 3:14 AM, Prasath Rajan wrote:

> Hi,
> I am running postgres in ubuntu,
>
> When I run below query,
>
> SELECT * FROM PG_TIMEZONE_NAMES
>
> IST "Asia/Kolkata" is not there.
>
> How to get my timezone.

This isn't really a pgadmin question, but the answer is that the timezone database uses the pre-2001 spelling:

Asia/Calcutta | IST | 05:30:00 | f

Cheers,
M

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-04-16 07:18:19 Re: pgAdmin 1.2.2 on W7 - Editor won't open
Previous Message Prasath Rajan 2011-04-15 07:14:06 Asia/kolkatta timezone