On 5/11/2011 8:14 PM, John wrote:
> I am in situation where I need to keep as much logic as possible within
> SQLite. However the query that I need to perform does not seem to be
> possible to perform.
>
> let's say I have a table with columns for each day of the week
>
> create table seven_days
> (monday_value integer,
> tueday_value integer,
> wednesday_value integer,
> ... );
>
> I want to select value from whatever day it is today. So if today is
> Tuesday, select from tuesday_value.
>
> Can I do it with pure SQlite?
select case strftime('%w', 'now')
when 0 then sunday_value
when 1 then monday_value
...
else saturday_value
end
from seven_days;
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
