| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Alex Falkowski" <alex(at)l-o-u-d(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Timestamp |
| Date: | 2002-06-25 01:21:29 |
| Message-ID: | 3530.1024968089@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
"Alex Falkowski" <alex(at)l-o-u-d(dot)com> writes:
> I get the following output, which clearly marks to me that setTimestamp is =
> doing something wrong
> PostgreSQL 7.2 JDBC2
> 2002-06-22 00:00:00.0
> SELECT o.id FROM question o WHERE (o.question_date =3D '2002-06-21 14:00:00=
> .00+00')
It's not apparent to me that this is wrong --- is the second println
reporting the Timestamp's value in your local timezone? I guess that
your local timezone is GMT+10 from your Date: header, in which case
the two values are perfectly consistent.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2002-06-25 01:29:32 | Re: Timestamp |
| Previous Message | Timothy Reaves | 2002-06-25 00:14:24 | Re: Posgresql - openoffice-JDBC |