Re: fetching specific date from datetime field

select * from table where substring(timestampField,1,8) = 'MMDD' from Perl, execute this statement and then process each returned row - hcir > My mysql database is set up having a field cdate > -> cdate datetime > > has the format > > -00-00 00:00:00 > > If I want to fetch rows for sa

fetching specific date from datetime field

Hi All My mysql database is set up having a field cdate -> cdate datetime has the format -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