Re: A creepy story about dates. How to prevent it?
От | Ron Johnson |
---|---|
Тема | Re: A creepy story about dates. How to prevent it? |
Дата | |
Msg-id | 1056002068.592.36.camel@haggis обсуждение исходный текст |
Ответ на | Re: A creepy story about dates. How to prevent it? (Paul Thomas <paul@tmsl.demon.co.uk>) |
Список | 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 по дате отправления: