Date format DD-MM-YYYY

Hi guys and gals,

I am having a few problems working with a SELECT query on dates in a table using a DD-MM-YYYY (English format) as a column format.

I simply want to select * from table where (active_date = today);

where active date's format is DD-MM-YYY.

Anyone help??

I have written a class in php to deal with it business side, but would really rather process on the DB.

Cheers,

If your date is saved in MySQL using YYYY-MM-DD, you can use the DATE_FORMAT functions to reformat it correctly.

For example you select could look like this:

Select DATE_FORMAT(mydate, '%m/%d/%Y') as mydate;

Hope this helps.
Meekos