Re: A creepy story about dates. How to prevent it?
От | Paul Thomas |
---|---|
Тема | Re: A creepy story about dates. How to prevent it? |
Дата | |
Msg-id | 20030619000926.A19922@bacon обсуждение исходный текст |
Ответ на | Re: A creepy story about dates. How to prevent it? ("scott.marlowe" <scott.marlowe@ihs.com>) |
Ответы |
Re: A creepy story about dates. How to prevent it?
|
Список | pgsql-general |
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 | +------------------------------+---------------------------------------------+
В списке pgsql-general по дате отправления: