Error in DATEADD with unit MONTH
---------------------------------
Key: CORE-5386
URL: http://tracker.firebirdsql.org/browse/CORE-5386
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.5
Reporter: Oliver Wurdak
Priority: Minor
the following select statement
Select DATEADD(11 MONTH TO CAST('02/29/2012' as DATE))
from RDB$DATABASE
returns 01/31/2013, which is an error (it should be 01/29/2013)
DATEADD(11 MONTH TO CAST('02/28/2013' as DATE)) evaluates correctly to
01/28/2014
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
The Command Line: Reinvented for Modern Developers
Did the resurgence of CLI tooling catch you by surprise?
Reconnect with the command line and become more productive.
Learn the new .NET and ASP.NET CLI. Get your free copy!
http://sdm.link/telerik
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
