Apologies, if it is not the right forum. But I think as I came across this query problem while working on android, I thought I would gt some help on this
I have a field datetime data type. i need something like select * from mytable where strftime('%d', mydate) = 14; i need all the records whose day of the date in mydate is 14 this should work according to sqlite3 docs, but it is not working. Any help is appreciated http://www.sqlite.org/lang_datefunc.html regards -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en