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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
