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] -----------------------------------------------------------------------------