Hi Anoop,
In order to validate a date I am using next query:
select date_format(date_sub(date_add('<yourdate>', interval 1 day), interval
1 day),'%Y%m%d') = date_format('<yourdate>','%Y%m%d');
It will give you 1 if date is valid.
Best regards,
Mikhail.
----- Original Message -----
From: "Anoop kumar V" <[EMAIL PROTECTED]>
To: "Chris Ramsay" <[EMAIL PROTECTED]>; <[email protected]>
Sent: Friday, April 29, 2005 6:10 PM
Subject: Re: Date validation using mysql
No problem - I followed up and found out that this function is not
available. THought probably you were referring to a later version of Mysql..
anyways...
We use Java - and maybe I could use that - I was just wondering if I could
help reinventing something already there.
Thanks so much for the suggestions/
Anoop
On 4/29/05, Chris Ramsay <[EMAIL PROTECTED]> wrote:
>
> Anoop
>
> <snip>
> You could try checkdate()...
> </snip>
>
> Apologies for erroneous advice - I am evidently suffering from list
> psychosis...
>
> Chris
>
--
Thanks and best regards,
Anoop
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
