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

From Paul Jungwirth
Subject Re: date with month and year
Date
Msg-id 555E19C9.504@illuminatedcomputing.com
Whole thread Raw
In response to Re: date with month and year  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: date with month and year  (Daniel Torres <nobeeakon@gmail.com>)
Re: date with month and year  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
> You really shouldn't use WITHOUT TIME ZONE.

I'd like to know more about this. Can you say why? Are there any
articles you'd recommend? I'm fond of normalizing all times to UTC and
only presenting them in a time zone when I know the current
"perspective". I've written about that approach in a Rails context here:

http://illuminatedcomputing.com/posts/2014/04/timezones/

I find that this helps me to ignore time zones in most parts of my
application and cut down on my timezone-related bugs.

Thanks!
Paul





pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: Re: date with month and year
Next
From: Andomar
Date:
Subject: Re: Replicate over pgbouncer?