My table has a date field defined as ‘datetime year to second’
When selected, it looks like “2009-08-31 10:55:27”.
I have never seen this date definition before.
My query needs to retrieve all rows whose date is yesterday,
dropping hour, minute, & second.
Can anyone advise me of the syntax ?
Many thanks

The simplest way to do that is to use the date function, e.g.

select date(your_datetimefield)
from your_table
where date(your_datetimefield) = (TODAY -1)

thanks bigcalm
this works a treat.
best wishes