Postgres Pro
Downloads
Home   >   mailing lists

Having a hard time understanding time zone - Mailing list pgsql-jdbc

From Robert DiFalco
Subject Having a hard time understanding time zone
Date
Msg-id CAAXGW-yLEavhB-Asex8_KEutgEHH5zPMEksgOF0JPieQrTXrWA@mail.gmail.com
Whole thread Raw
Responses Re: Having a hard time understanding time zone  (Dave Cramer <pg@fastcrypt.com>)
Re: Having a hard time understanding time zone  (David Johnston <polobo@yahoo.com>)
List pgsql-jdbc
Tree view
Does the JDBC driver set the timezone to the origin timezone for each statement?

I have a date column in a table. My Postgres server is running in UTC. My java app is running in "America/Los_Angeles".

I would expect a DEFAULT column of NOW() to insert the current UTC time. While if I specify the time with new Date() from Java I would expect the Java timezone. 

But oddly both set the date field to the localized time in Java and not the UTC time.

This makes me think that the driver is somehow forcing the session timezone.

If so is there any way to make the driver communicate with the server in UTC?

Thanks!

pgsql-jdbc by date:

Previous
From: Tomonari Katsumata
Date:
Subject: Re: About binaryTransfer.
Next
From: Dave Cramer
Date:
Subject: Re: Having a hard time understanding time zone