Igor,
What you are suggesting will not work. You can only select values not
columns using case.
select case strftime('%w', 'now')
when 0 then sunday_value
when 1 then monday_value
...
else saturday_value
end
from seven_days;
On Wed, May 11, 2011 at 8:30 PM, Igor Tandetnik <[email protected]> wrote:
> 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
>
--
~John
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
