Re: Strange behaviour of greatest() function
'' is an invalid datetime/timestamp value, so ...
insert into testing (time) values(greatest(now(),''));
... looks like a coding error, so the bug appears to be that comparison of '' with a literal datetime value suppresses the error. Consider reporting the bug.
Subject
Written By
Posted
September 12, 2018 06:22PM
Re: Strange behaviour of greatest() function
September 12, 2018 07:40PM
September 13, 2018 03:17PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.