Category Archives: Oracle SQL Functions

Function Description Function NEXT_DAY returns the date of the first weekday named by char that is later than the date. Examples SELECT NEXT_DAY(‘02.11.2011′,’FRIDAY’) AS “NEXT DAY” FROM dual; Result: 4.11.2011 SELECT NEXT_DAY(‘30.11.2011′,’FRIDAY’) AS “NEXT DAY” FROM dual; Result: 2.12.2011

Function DescriptionWatch Full Movie Streaming Online and Download Function MONTHS_BETWEEN returns the number of months between two dates. Examples Oracle PL/SQL SELECT MONTHS_BETWEEN(TO_DATE(‘02.02.2010′,’DD.MM.YYYY’), TO_DATE(‘01.10.2010′,’DD.MM.YYYY’)) FROM dual; Result: -7,96774193548387 SELECT MONTHS_BETWEEN(TO_DATE(‘01.10.2010′,’DD.MM.YYYY’), TO_DATE(‘02.02.2010′,’DD.MM.YYYY’)) FROM dual; Result: 7,96774193548387 SELECT MONTHS_BETWEEN(TO_DATE(‘02.02.2010′,’DD.MM.YYYY’), TO_DATE(‘02.02.2010′,’DD.MM.YYYY’)) FROM dual; … Continue reading →

Function Description Function LAST_DAY returns the last date of the month in DATE datatype. Examples SELECT SYSDATE, LAST_DAY(SYSDATE) “LAST DAY OF MONTH” FROM dual; Result: SYSDATE LAST DAY OF MONTH 15.11.2011 30.11.2011

Function Description Function TO_DATE returns the value of DATE datatype from a VARCHAR2, NVARCHAR2, CHAR, NCHAR datatype. Here you will find Oracle date format elements. Examples SELECT TO_DATE(‘23.07.2011’, ‘DD.MM.YYYY’) FROM dual Result: 23.07.2011 SELECT TO_DATE(‘23.07.2011 15:43:46’, ‘DD.MM.YYYY HH24:MI:SS’) FROM dual Result: … Continue reading →

Function Description Function DBTIMEZONE returns the value of database time zone. Examples SELECT DBTIMEZONE FROM dual Result: -05:00

Function Description Function CURRENT_TIMESTAMP returns current date and time in the session time zone. Examples SELECT CURRENT_TIMESTAMP FROM dual Result: 29.8.2011 10:36:32,789650 +02:00 SELECT CURRENT_TIMESTAMP(1) FROM dual Result: 29.8.2011 10:40:30,8 +02:00

Function Description Function ADD_MONTHS returns the date PLUS or MINUS integer months. Examples SELECT ADD_MONTHS(SYSDATE, 1) FROM dual Result: 29.9.2011 10:24:48 SELECT ADD_MONTHS(SYSDATE, -1) FROM dual Result: 29.7.2011 10:26:35