Re: A creepy story about dates. How to prevent it? - Mailing list pgsql-general

From Ron Johnson
Subject Re: A creepy story about dates. How to prevent it?
Date
Msg-id 1056002068.592.36.camel@haggis
Whole thread Raw
In response to Re: A creepy story about dates. How to prevent it?  (Paul Thomas <paul@tmsl.demon.co.uk>)
List pgsql-general
On Wed, 2003-06-18 at 18:09, Paul Thomas wrote:
> On 18/06/2003 22:09 scott.marlowe wrote:
> > [snip]
> > Why bother checking for wrong dates sometimes (i.e. 03/33/2003) but not
> > all the time (i.e. 13/03/2003)?
>
> ISTR that DB2 used to do the same (maybe still does - haven't used it for
> a few years). Still, IMHO, it is frustrating. I would rather have the db
> be ultra-strict, forcing me to handle dates correctly and rigorously in my
> app.
>
> > [snip]
> > I do plenty of format checking, this isn't the same.  This is range
> > checking.  I expect my database to do that for me.
>
> Agreed, although if the user gets his data thrown back at him by the db
> then I feel that this is a bug in my program. YMMV.

I hate to say, "Me too!", but I do agree with Paul and Scott.

--
+-----------------------------------------------------------+
| Ron Johnson, Jr.     Home: ron.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson |
|                                                           |
| "Oh, great altar of passive entertainment, bestow upon me |
|  thy discordant images at such speed as to render linear  |
|  thought impossible" (Calvin, regarding TV)               |
+-----------------------------------------------------------


pgsql-general by date:

Previous
From: Avi Schwartz
Date:
Subject: Can inherited tables help in this case?
Next
From: Joel Rees
Date:
Subject: Re: A creepy story about dates. How to prevent it?