sql filter for date year code example

Example: filter data on date sql

WHERE dates >= '20121211'
  AND dates < '20121214'  -- i.e. 00:00 of the next day