Convert Varchar to Date Format in mysql

SELECT *  FROM `tMembers` where str_to_date(sBirthDay,”%m/%d/%Y”) between str_to_date(’12/15/1985′,”%m/%d/%Y”) and str_to_date(’09/22/1987′,”%m/%d/%Y”)


Comments

Leave a Reply

Your email address will not be published. Required fields are marked *