fetching specific date from datetime field

[aman mysql]

Hi All

My mysql database is set up having a field cdate
-> cdate datetime

has the format

0000-00-00 00:00:00

If I want to fetch rows for say the date 2000-12-19, I do it using perl
(it's a tediuos code)
Is there a way to do it using sql queries
Also how can I get betwee two specific date that I may mention.

Thanks
Sincerely
Aman