Woww - this is great - I think this is exactly what I wanted!!
Thanks a Ton Mikhail. :-)
Anoop
On 4/29/05, Mikhail Entaltsev <[EMAIL PROTECTED]> wrote:
>
> 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
>
>
--
Thanks and best regards,
Anoop
