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?
See Question&Answers more detail:osI 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?
See Question&Answers more detail:os