working with a date

I'm wanting to return all the data from my database for an exact date. My
date field is a timestamp. Here is the code that I have been trying to use:

select * from production where date like '2007-05-30';

or

select * from production where date = '2007-05-30';

Thanks for any help that you can provide.

A

On 4 Jun, 15:49, "Auddog" <wil...@hotmail.com> wrote:
> I'm wanting to return all the data from my database for an exact date. My
> date field is a timestamp. Here is the code that I have been trying to use:
>
> select * from production where date like '2007-05-30';
>
> or
>
> select * from production where date = '2007-05-30';
>
> Thanks for any help that you can provide.
>
> A

Look at:
http://dev.mysql.com/doc/refman/5.0/...on_date-format