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

From Adrian Klaver
Subject Re: date with month and year
Date
Msg-id 555E9898.5050701@aklaver.com
Whole thread Raw
In response to Re: date with month and year  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
On 05/21/2015 11:56 AM, Steve Crawford wrote:
> On 05/21/2015 10:45 AM, Paul Jungwirth wrote:
>>> You really shouldn't use WITHOUT TIME ZONE.
>>
>> I'd like to know more about this. Can you say why?
>
> Start by reading about the date and time data types with special
> attention to section 8.5.3:
> www.postgresql.org/docs/current/static/datatype-datetime.html
>
> Now go back and read it again and experiment a while until it makes
> sense. As Adrian Klaver so eloquently put it, "If I have learned
> anything about dealing with dates and times, is that it is a set of
> exceptions bound together by a few rules. Every time you think you have
> the little rascals cornered, one gets away." This is also a very good
> reason to avoid reinventing the wheel.
>

The check is in the mail:)

> Cheers,
> Steve
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Allowing postgresql to accept 0xff syntax for data types that it makes sense for?
Next
From: Alvaro Herrera
Date:
Subject: Re: date with month and year