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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
