date(year to second field)

Hi I have table with field "year to second". I need to prepare reports quiet oftern the transactions on day basis. I would like to know which is efficient to use. select * from taskresult where date(startedat) = today or select * from taskresult where startedat >="1998-04-29 00:00:00" andstartedat <="1998-04-29 59:59:59" Could you please mail me sukumar@gte.net Thank you sukumar konduru