Hi,

I use mysql4.0.24. Date is stored as string('15/01/2008') in mysql table.Now i want to filter the records based on the date column using <,> and between operatoes.But i am unable to do it.How can i convert the date column from string data type to date data type and check it.

I use cast() function.But it is not properly worked in mysql4.0.24.Please anyone tell me the query.

Thanks in advance.

use the CAST syntax

_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google

Please post the query you used, perhaps it helps to see what you did wrong.

_________________
"I don't believe in endings, I only believe in new beginnings"