Re: date with month and year

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

In response to

Browse pgsql-general by date

  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?