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? > > When I add '+1 month' to the example data, the example date > has 31 days added to it. Which is correct. > > When I subtract '-1 month' the date only gets 28 days > subtracted from it. > > Surely adding or subtracting a month modifier to a date > should be the same number of days in each direction? > D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users