[sqlite] Re: dates and times in sqlite

[Igor Tandetnik]

Mark Wyszomierski <[EMAIL PROTECTED]>
wrote:
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

select * from my_table
where strftime('%w', timestamp) = '2';

Igor Tandetnik 


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------