tag:blogger.com,1999:blog-106449775438946661.post18653526043456307..comments2024-03-19T05:14:38.879-07:00Comments on Overcoming Fear: Non-ANSI Oracle ADD_MONTHS FunctionTim Myerhttp://www.blogger.com/profile/01514263555690798238noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-106449775438946661.post-4514482077630850862010-03-03T13:37:07.994-08:002010-03-03T13:37:07.994-08:00Tks a lot!!!Tks a lot!!!Propietariohttps://www.blogger.com/profile/00431613311912405489noreply@blogger.comtag:blogger.com,1999:blog-106449775438946661.post-44055950049478077692009-06-30T09:42:49.504-07:002009-06-30T09:42:49.504-07:00Great addition to this entry! Thanks very much fo...Great addition to this entry! Thanks very much for the case statement.<br />---Tim---Tim Myerhttps://www.blogger.com/profile/01514263555690798238noreply@blogger.comtag:blogger.com,1999:blog-106449775438946661.post-280847359165452412009-06-30T09:32:26.642-07:002009-06-30T09:32:26.642-07:00ONE MAY USE A CASE STRUCTURE IN A QUERY FOR THE SA...ONE MAY USE A CASE STRUCTURE IN A QUERY FOR THE SAME EFFECT LIKE THIS<br />IF A FUNCTION IS NOT POSSIBLE <br /><br />select case when to_char(curdate, 'DD') < to_char(add_months(curdate, 1), 'DD') THEN curdate + numtoyminterval(1, 'month') ELSE add_months(curdate, 1) end into newdate FROM DUAL;<br /><br />THANKSLighthousehttps://www.blogger.com/profile/18307350579532737772noreply@blogger.comtag:blogger.com,1999:blog-106449775438946661.post-11514157422242962402008-11-18T07:10:00.000-08:002008-11-18T07:10:00.000-08:00Jó napot László,Thanks for the comment, and I'm ha...Jó napot László,<BR/>Thanks for the comment, and I'm happy to have been of help. If you come across any improvements, please let me know!<BR/>----Tim-----Tim Myerhttps://www.blogger.com/profile/01514263555690798238noreply@blogger.comtag:blogger.com,1999:blog-106449775438946661.post-41589746357852133472008-11-18T02:44:00.000-08:002008-11-18T02:44:00.000-08:00We've run into this problem recently, so thanks fo...We've run into this problem recently, so thanks for your nice solution! :)Unknownhttps://www.blogger.com/profile/18178832319451536135noreply@blogger.com