Hi,
I've made a text field called "timestamp" which has dates in the form:
YYYY-MM-DD HH:MM:SS
I want to test if the day portion is a Tuesday for example - something like:
SELECT * FROM my_table WHERE DAY(timestamp) = TUESDAY
is something like that at all possible? I've looked at the extended
functions here:
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
but am unsure of how to take advantage of them.
Thank you,
Mark
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
