Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5, 10.0, 10.1, 10.2.14, 10.2, 10.3
-
None
Description
select DATE(SYSDATE()), DATE(DATE('2018-11-01')-1);
– Results in invalid date 2018-11-00
select DATE(SYSDATE()), DATE(DATE('2018-11-30')+1);
– Results in NULL
Both the cases should have returned NULL or yield expected dates as 2018-10-31 and 2018-12-01 respectively