Howdy. How do I select a year if my date field is stored "yyyy-mm-dd". I tried the below and no records show.
WHERE daysOff.dayOff= YEAR('2007')
Assuming fields are named as described and daysOff.dayOff is a date field or a datetime field ...
WHERE YEAR(daysOff.dayOff) = '2007'
