On Tue, 13 Oct 2009, D. Richard Hipp wrote: > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > From: D. Richard Hipp <d...@hwaci.com> > Subject: Re: [sqlite] Bug in date() function ?? > > > On Oct 13, 2009, at 12:57 PM, Keith Roberts wrote: > >> Just been messing about with the date functions, and there >> appears to be an inconsistency when adding a month >> modifier. I'm running Fedora 10. >> >> From: http://www.sqlite.org/lang_datefunc.html >> >> "Thus, for example, the data 2001-03-31 modified by '+1 >> month' initially yields 2001-04-31, but April only has 30 >> days so the date is normalized to 2001-05-01." > > Did you happen to read the previous sentence in the documentation?
Yes, I've read it again Richard. As the '+1 month' modifier modified the date by adding 31 days to normalise the date upwards, I expected the '-1 month' modifier to work in a similar fashion, and normalise the date *downwards* also by an interval of 31 days. Kind Regards, Keith Roberts _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users