Re: A creepy story about dates. How to prevent it?

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.

regards

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+