Re: Checking if a date is correct

2001-01-21 Thread Bob Hall
>try doing >"SELECT UNIX_TIMESTAMP('1990-2-31')" >and you'll get a number. >This is very weird, since this is an incorrect date. > >Is there any way to figure out if a date is correct in mysql >SQL implementation? And why UNIX_TIMESTAMP does >not return NULL for incorrect date? Sir, this seems to

RE: Checking if a date is correct

2001-01-21 Thread Carsten H. Pedersen
> -Original Message- > From: Artem Koutchine [mailto:[EMAIL PROTECTED]] > Sent: Sunday, January 21, 2001 1:44 PM > To: [EMAIL PROTECTED] > Subject: Checking if a date is correct > > > try doing > "SELECT UNIX_TIMESTAMP('1990-2-31')" > and you'll get a number. > This is very weird, since