Get month from DATETIME in sqlite

Question

I am trying to get extract the month from a DATETIME field in SQLite. month(dateField) does not work as well as strftime('%m', dateStart).

Any ideas?

Answer 1

I don't understand, the response is in your question :

select strftime('%m', dateField) as Month ... 

Answer 2

SELECT strftime('%m', datefield) FROM table  

If you are searching the month name, text month names does not seems to be supported by the core distribution of SQLite