tag:blogger.com,1999:blog-8873109125023142810.post316660969436499499..comments2024-03-28T16:58:51.302+05:30Comments on Let's Develop in Oracle: Prefer Oracle Native Date Arithmetic over ANSI INTERVALNimish Garghttp://www.blogger.com/profile/15795821721808548808noreply@blogger.comBlogger8125tag:blogger.com,1999:blog-8873109125023142810.post-83582547790515743482016-08-31T11:08:27.951+05:302016-08-31T11:08:27.951+05:30thanks very much for a very important topic, i rea...thanks very much for a very important topic, i really appreciate your efforts. best regards.Ahmed Haroonhttps://www.blogger.com/profile/06819987887669047981noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-53822035847446932522016-03-12T11:18:49.735+05:302016-03-12T11:18:49.735+05:30Very useful, thanks. Even if it could not be consi...Very useful, thanks. Even if it could not be considered as a bug, these INTERVAL operator are not usable for me.Pascal Lecontenoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-65173683658261937482016-03-11T09:53:55.389+05:302016-03-11T09:53:55.389+05:30Thank you! Very interesting. Have idea to review c...Thank you! Very interesting. Have idea to review code, tomorrow.Denis Burkhanovnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-46352252294969999072016-03-10T15:35:58.182+05:302016-03-10T15:35:58.182+05:30Interval is basically ANSI standard, so Oracle has...Interval is basically ANSI standard, so Oracle has to behave as per standard until ANSI itself changes it.Nimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-87501584425450479032016-03-10T14:45:16.534+05:302016-03-10T14:45:16.534+05:30Very interesting. One would've thought that O...Very interesting. One would've thought that Oracle would use a consistent definition of what constitutes a "month".Jeff Harrisnoreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-31084742573626612392016-03-08T08:45:34.331+05:302016-03-08T08:45:34.331+05:30Thanks for your comment and explanation.
I never ...Thanks for your comment and explanation.<br /><br />I never said INTERVAL functionality has bug. What I am trying to say is, if INTERVAL is not used properly without carefully reading docs, as there is a difference between INTERVAL and Oracle Native Date Arithmetic, it may lead your code to have bugNimish Garghttps://www.blogger.com/profile/15795821721808548808noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-12421384006727109362016-03-08T07:02:18.055+05:302016-03-08T07:02:18.055+05:30Excellent writeup.
I have to gently disagree with...Excellent writeup.<br /><br />I have to gently disagree with you on calling this a "bug" however. Any behaviour that conforms to the documentation is not a bug, by definition. Neither is an exception evidence of a defect.<br /><br />A "bug" for you might be "expected and desired" behaviour for someone else (e.g. someone might consider it a bug that ADD_MONTHS(DATE'2000-04-30',1) results in 31 May rather than 30 May!). It just depends on the business requirements.<br /><br />Certainly, if you use INTERVAL arithmetic, you have to add an exception handler to handle this case.<br /><br />ThanksJeffrey Kemphttps://www.blogger.com/profile/04255101699328756710noreply@blogger.comtag:blogger.com,1999:blog-8873109125023142810.post-87838608914840682762016-03-07T13:02:12.497+05:302016-03-07T13:02:12.497+05:30Very useful info.. thanks A lot NimishVery useful info.. thanks A lot NimishArun Kumarnoreply@blogger.com