Re: [sqlite] dates and times in sqlite

First make sure that you store the date in Julian format by using the julianday function. Then you should be able to get the day of the week by take modulo 7 of the julian date. You can use the strftime function to do that - **strftime( FORMAT, TIMESTRING, MOD, MOD, ...) ** ** Return a

[sqlite] dates and times in sqlite

Hi, I've made a text field called "timestamp" which has dates in the form: -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