Re: jbuilder and timestamps

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@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110