Author Archives: admin

Function Description Function ROUND (date) returns the date rounded to the unit specified by the date format model. If date format model is omited then date will be rounded to the nearest day. Examples SELECT ROUND(TO_DATE(‘30.11.2011′),’MONTH’) AS “ROUND DATE” FROM … Continue reading →

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