search by date

I have a form field that I am populating with a date (mm/dd/yyyy), and I want to search a database column of dates (yyyy-mm-dd hh:mm:ss).

I am new to php and having problems finding matching dates in the database... Can anyone show me a sample query?

Thanks for any help!

b

Well, first you gonna need to re-format the date in the form field to match the date string in your database:

list($month, $day, $year) = split("/", "mm/dd/yyyy");
$new_date = $year . "-" . $month . "-" . $day;

You can use substring in your sql statement to search on part of the date field:

select * from db where substring(date_stamp, 1, 10) = 'yyyy-mm-dd'

Some good resources for you to take a look at:
URL
URL