Unanswered: Advice on 'datetime year to date' for novice
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 ?