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, only registered users may post in this forum.

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.