Add a month

[Jarek Zgoda]

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/