Are you asking if SQLite itself can figure out which day it is and retrieve the appropriate data?
Don Ireland -----Original Message----- From: John <tauru...@gmail.com> To: sqlite-users@sqlite.org Sent: Wed, 11 May 2011 7:15 PM Subject: [sqlite] Dynamic SQL for SQLite? 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? -- ~John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
