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]>; <mysql@lists.mysql.com> 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]