mysql date field
Posted: Tue Mar 17, 2009 11:46 pm
Dear All,
i have a form where the user will enter the date as (dd/mm/yyy) formate then the user will click the submit button. the submit button onclick event will go to the database and check for all records that occured in the date that user entered but because mysql saves dates as (yyy-m-d) the query will result "0" records! how i can fo that?
Thanks.
i have a form where the user will enter the date as (dd/mm/yyy) formate then the user will click the submit button. the submit button onclick event will go to the database and check for all records that occured in the date that user entered but because mysql saves dates as (yyy-m-d) the query will result "0" records! how i can fo that?
Thanks.