Re: Timezone conversion woes

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Christian Cryder <c(dot)s(dot)cryder(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Timezone conversion woes
Date: 2005-07-14 22:41:29
Message-ID: 00A0FDC4-D515-4487-85AE-931C81EDF21F@fastcrypt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

When you create the column in the database

do create table foo( t timestamp without time zone )

Dave
On 14-Jul-05, at 3:25 PM, Christian Cryder wrote:

> On 7/14/05, Dave Cramer <pg(at)fastcrypt(dot)com> wrote:
>
>> Yeah, create your timestamps without timezones and they will not be
>> converted.
>>
>
> Dave, how exactly do you do this? Especially if I am trying to read a
> date out of the db (there is no timezone info there, but by the time I
> access the data via ps.getDate() its already there).
>
> Any suggestions would be greatly appreciated.
>
> Thanks,
> Christian
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dianne Yumul 2005-07-14 23:47:27 No. of rows on result set
Previous Message Christian Cryder 2005-07-14 19:25:38 Re: Timezone conversion woes