Click here to Skip to main content
16,016,781 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
there some way to do it? actually i'am using android studio i have the next code but does not work, not display results

Cursor c = db.rawquery("select * from myTable where strftime('%m',myDate)= '07'",null);
Posted
Comments
Abhinav S 5-Jul-15 1:04am    
Run the same query in sql lite to check whether you get some output.
Afzaal Ahmad Zeeshan 5-Jul-15 4:18am    
Why are you having Pascal and Delphi? Make sure what are you going to use and on which framework?

Tagging a question with many frameworks would never give you a valid solution. Remove inappropriate tags from your question.

1 solution

See https://www.sqlite.org/lang_datefunc.html[^]; myDate should be a string value of a date.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900