IL PROTECTED]>
> To: "Chris Ramsay" <[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 referri
inal Message -
From: "Anoop kumar V" <[EMAIL PROTECTED]>
To: "Chris Ramsay" <[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 prob
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
Anoop
You could try checkdate()...
Apologies for erroneous advice - I am evidently suffering from list psychosis...
Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You can, sort of. You can use a type of query like this:
select if(now()>'2005-04-28', 1, 0);
Which will return a 1 or a 0 if the date is greater than the current
date/time. But that's a very weak comparison, prone to error, since the
date must be in the MySQL readable format. So while you could
You could try checkdate()...
chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
So is there a function in mysql that I can call to validate dates??
Or do I need to build it?
Thanks,
Anoop
On 4/29/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
>
> Anoop kumar V <[EMAIL PROTECTED]> wrote on 04/29/2005 11:00:11 AM:
>
> > Is it possible to do a date field validation us
Anoop kumar V <[EMAIL PROTECTED]> wrote on 04/29/2005 11:00:11 AM:
> Is it possible to do a date field validation using an sql query.
>
> Its like we have an html field- its a free form text field and the end
user
> should type in a valid date, of course in a predefined format only
> (MM/dd/yy
