Paul Boddie napisał(a): >>what do you expect d_new to be after the operation ? if the answer >>is date(2006,3,17), what's date(2006,1,31) plus one month? > > February 31st, of course: > > http://sql-info.de/mysql/gotchas.html#1_14
MS SQL Server documentation marks dateadd() result as non-deterministic in Transact-SQL reference. Adding 1 month to jan 31st gives feb 28 or 29, depending on year. It's not that bad, providing you know this behaviour. ;) -- Jarek Zgoda http://jpa.berlios.de/ -- http://mail.python.org/mailman/listinfo/python-list