From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Steve Crawford <scrawford(at)pinpointresearch(dot)com>, Paul Jungwirth <pj(at)illuminatedcomputing(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: date with month and year |
Date: | 2015-05-22 02:46:48 |
Message-ID: | 555E9898.5050701@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2015-05-22 04:04:27 | Re: date with month and year |
Previous Message | Bill Moran | 2015-05-22 02:46:33 | Re: Allowing postgresql to accept 0xff syntax for data types that it makes sense for? |