Hi Jags, I am not sure if this is quite what you need but you could try this.
1.Do not use the DateTime Data Type within SQLite, since in my experience this tends to be very slow. Store the System Time <code>System.currentTimeMillis()</code> instead. 2.Use the Calendar to define the Date you want and the date after that 3.as the selection (WHERE statement) within your query, try something like date >= day.getTimeInMillis AND date < tomorrow.getTimeInMillis This will only work if you need the specific date of a month and not for every 14th . Hope this helps Regards Aracos On Dec 14, 2:28 pm, Jags <[email protected]> wrote: > 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
