Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

6
  • @ahmd0 What is strftime?Can you please elaborate the query in detail Commented Jan 4, 2012 at 10:17
  • @Eshwar Chaitanya, Follow the link in the answer. Commented Jan 4, 2012 at 19:31
  • @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/… Commented Jan 5, 2012 at 5:12
  • 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" Commented Mar 18, 2014 at 13:35
  • 1
    @Neon Warge, = '4' is quite different than = '04' Commented Apr 4, 2015 at 18:18