SQLite SELECT date for a specific month

I was using Microsoft's Jet database engine before. And, say, if I needed to select entries for a specific month I do this:

SELECT * FROM `table name` WHERE MONTH(`date column`)=4

But how do you do the same with SQLite?

11
задан Joe Doyle 1 May 2012 в 00:00
поделиться