SQLite SELECT date for a specific month

Question

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?

Itay Grudev · Accepted Answer · 2015-09-15 12:54:07Z

51

How about

SELECT * FROM table_name WHERE strftime('%m', date_column) = '04'

Date And Time Functions

edited Sep 15, 2015 at 12:54

Itay Grudev

7,5644 gold badges60 silver badges97 bronze badges

answered Apr 14, 2011 at 20:58

ikegami

392k17 gold badges293 silver badges559 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Eshwar Chaitanya Over a year ago

@ahmd0 What is strftime?Can you please elaborate the query in detail

ikegami Over a year ago

@Eshwar Chaitanya, Follow the link in the answer.

Eshwar Chaitanya Over a year ago

@ikegami Yeah I have gone through the link,I have understood but that's not working for me,If you find some free time,please navigate to this link,I have struck with the retrieve issue regarding date stackoverflow.com/questions/8725685/…

sherin Over a year ago

Can you help this is not working for me my code is below: "SELECT * FROM USER_DATA where strftime('%m', created_date) ='04'"; "created_date"->field name . In database my date format is "MM-dd-yyyy"

ikegami Over a year ago

@Neon Warge, = '4' is quite different than = '04'

|

manji · Accepted Answer · 2014-12-19 11:12:57Z

13

SELECT * FROM `table name` WHERE strftime('%m', `date column`) = '04'

sqlite date&time functions

edited Dec 19, 2014 at 11:12

answered Apr 14, 2011 at 20:52

manji

48k5 gold badges98 silver badges104 bronze badges

1 Comment

ahmd0 Over a year ago

Haha. I knew it was simple. Thanks!

Collectives™ on Stack Overflow

SQLite SELECT date for a specific month

2 Answers 2

6 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Linked

Related