| From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: jbuilder and timestamps |
| Date: | 2002-11-04 17:24:06 |
| Message-ID: | 20021104122406.H16828@mail.libertyrms.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
On Fri, Nov 01, 2002 at 04:09:44PM -0600, miguel angel rojas aquino wrote:
> we are developing an application using jbuilder 5 and postgresql
> 7.2.2-1PGDG, and found some strange beheavior with the timestamps, say
> for example, in our database we have a record like this one:
>
> id_emp | name | date
> --------+--------+------------------------
> 1004 | laura | 2002-09-19 00:00:00-05
>
> but when displaying this same date in a textfield in our application, it
> says the date is 2002-09-18 23:00:00!!!!
It sounds like your PGTZ setting is wrong somewhere. In your case,
it appears you want Eastern time. So make sure that your PGTZ
setting is EST5EDT.
A
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Barry Lind | 2002-11-04 17:45:41 | Re: jbuilder and timestamps |
| Previous Message | Dave Cramer | 2002-11-04 17:18:56 | Re: |