Friday, 14 October 2011

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")