Meh. I have a solution, but I don't like it very much because it feels convoluted:
> sqlite> select strftime('%Y-%m-%d', julianday('2011-01-01') + digit) as d > from digits; > 2011-01-01 > 2011-01-02 > 2011-01-03 > 2011-01-04 > 2011-01-05 > 2011-01-06 > 2011-01-07 > 2011-01-08 > 2011-01-09 > 2011-01-10 > This takes advantage that JULIANDAY is in units of days. I'll go with this unless some guru suggests something cleaner. -- View this message in context: http://old.nabble.com/generating-mini-calendar%3A-DATE-and-quoting...-tp30896927p30897133.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users