Re: date with month and year - Mailing list pgsql-general

From Paul Jungwirth
Subject Re: date with month and year
Date
Msg-id 555E4F39.7050307@illuminatedcomputing.com
Whole thread Raw
In response to Re: date with month and year  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
> what you've said above is incorrect.
> All "WITH TIME ZONE" does is tell PostgreSQL to apply timezone
> conversions during various operations.  The stored data is represented
> as an epoch without any concept of the source data's timezone
> representation.

Oh, very interesting! Thank you for pointing that out. I'll have to
think some more about when I'd want that behavior.

Paul


pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Unit tests and foreign key constraints
Next
From: Brian Dunavant
Date:
Subject: Re: date with month and year