MySQL Forums
Forum List  »  Newbie

can't use between for a date (d-m-Y)
Posted by: bouchra amghar
Date: June 05, 2018 04:41AM

Hi everyone,

I should modify one of our old applications(php 4.2,mysql 3.23) in way to add a search by period .
Unfortunatly when I check the database , all dates are saving like 'd-m-Y'.
I test to convert this column to date with using date () or str_date but no result.
this column's type is string.

any suggestions or ideas to solve this prob

many thanks

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.