On Thu, Feb 10, 2011 at 02:47:29PM -0800, fearless_fool scratched on the wall:
>
> 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;
> This takes advantage that JULIANDAY is in units of days. I'll go with this
> unless some guru suggests something cleaner.
SELECT date( '2011-01-01', digit || 'days' ) AS d FROM digits;
-j
--
Jay A. Kreibich < J A Y @ K R E I B I.C H >
"Intelligence is like underwear: it is important that you have it,
but showing it to the wrong people has the tendency to make them
feel uncomfortable." -- Angela Johnson
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
