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
>
>
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 |