Hi all,
I'm using PostgreSQL 8.4.4, jdbc driver postgresql-8.4-701.jdbc4.jar and
last snapshot of Squirrel.
Sending the following sql:
select current_time, current_date, current_timestamp as timestamptz,
localtime, localtimestamp;
i get
timetz date timestamptz time timestamp
08:59:29 2010-05-18 2010-05-18 09:59:29.373 09:59:29
2010-05-18 09:59:29.373
and here's what it should be:
timetz | date | timestamptz | time |
timestamp
-----------------+------------+----------------------------+--------------+-------------------------
09:59:31.092+02 | 2010-05-18 | 2010-05-18 09:59:31.092+02 | 09:59:31.092
| 2010-05-18 09:59:31.092
The time zone information is missing from both timetz and timestamptz and
timetz time value is one hour behind what it should be (possibly it's
missing the daylight saving time).
I cannot find any config option nor any driver property to change this
behavior, is that a bug?
Regards,
Gabriele |