Re: Having a hard time understanding time zone

Re-posting, see quote


David Johnston wrote
>
> Robert DiFalco wrote
>> Well I feel a little crazy. But this is what I see.  I have a timestamp
>> without time zone column with a default value of current_timestamp.  In
>> PSQL I can see this value yields a UTC value. But when I insert from JDBC
>> (not setting that column) and then look at the value with PSQL I see a
>> PDT value?!  That is my JVM zone. When I get back to the office on Monday
>> I'll try to create a test case.
> If you have a "timestamp without time zone" then you are missing the whole
> point.  Specifically "if I look at the value with psql I see a PDT value"
> is technically impossible since you already told the system that you don't
> give a shit about the timezone.  What you are seeing is a time string that
> you mentally interpret (or client timezone gets associated with) to be
> PDT.  Use timestamp with time zone and you'll likely find yourself much
> less confused.
>
> Also, read this:
> http://www.depesz.com/2014/04/04/how-to-deal-with-timestamps/
>
> David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Having-a-hard-time-understanding-time-zone-tp5798914p5799284.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.