Re: OT : timestamps and jbuilder (help, please)

On Saturday 02 Nov 2002 10:25 pm, miguel angel rojas aquino wrote:
> hi everybody, hope any one can give me some insigth about this one, we
> are in great despair  :(
>
> 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!!!!

Are you absolutely certain that psql and your java application have the same
timezone in their environment? What happens with a select now()?

--
  Richard Huxton