Samuel Adam-2 wrote:
>
>
> http://www.sqlite.org/lang_datefunc.html
> http://www.sqlite.org/lang_select.html
> (and a few others)
> Very truly,
>
Hi SA:
So I've been reading those very pages carefully. And since the docs say
> Note that "±NNN months" works by rendering the original date into the
> YYYY-MM-DD format, adding the ±NNN to the MM month value, then normalizing
> the result.
>
I'm even more perplexed when the following one-liner isn't properly
normalized:
> sqlite> SELECT DATE("2011-01-32");
>
>
It returns a blank record rather than giving "2011-02-01", contrary to what
the documentation suggests. What am I missing?
--
View this message in context:
http://old.nabble.com/generating-mini-calendar%3A-DATE-and-quoting...-tp30896927p30897057.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
