tag:blogger.com,1999:blog-4818542164384221282.post3633154942840589597..comments2024-03-25T17:53:49.828+08:00Comments on Grassroots Oracle: Interval IssuesScott Wesleyhttp://www.blogger.com/profile/18106937181788036683noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-4818542164384221282.post-20477146199084651042009-08-06T15:53:20.496+08:002009-08-06T15:53:20.496+08:00Well that makes sense. I think it's good we ha...Well that makes sense. I think it's good we have the option. I guess it would depend on how you need your application to behave - and the example you gave is a good one.Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-4818542164384221282.post-37604591268762300672009-08-06T14:42:50.383+08:002009-08-06T14:42:50.383+08:00As I understand it, INTERVAL is part of the SQL st...As I understand it, INTERVAL is part of the SQL standard so oracle are following the rules. MONTHS_BETWEEN is Oracle specific, so they can make it work however they want.<br /><br />Personally, I like that INTERVAL fails rather than giving debatable responses. I've never been happy that adding one month to Feb 28th gives March 31st.SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.com