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

On Thu, 2003-06-19 at 09:54, Jonathan Bartlett wrote:
> > > The problem is that you can't do the check on the _field_ since it has
> > > already been converted to a date.
> >
> > You're right.  How about a "before insert" trigger?
>
> This suffers from the same problem, I believe.  If I weren't a lazy
> bastard, I check it :)

But you could code programatic to validate the date.

--
+-----------------------------------------------------------+
| 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)               |
+-----------------------------------------------------------