18. PL/SQL DATE-TIME Formatting | PL/SQL Developer Course | TechView Team | Hindi

Опубликовано: 23 Апрель 2026
на канале: TechView Team

#techviewteam #plsql
In this video we discuss about oracle PL/SQL Views & Materialized Views with practical example.
This is 15th video from series of videos about PL/SQL. so, you are requested to watch complete playlist for better understanding.

---video notes start from here-----
SELECT SYSDATE FROM DUAL;

SELECT TO_CHAR(CURRENT_DATE, 'MM-DD-YYYY') FROM DUAL;

SELECT TO_date('30/12/2022', 'DD-MM-YYYY') FROM DUAL;

SELECT ADD_MONTHS(SYSDATE, 5) FROM DUAL;

SELECT LOCALTIMESTAMP FROM DUAL;

SELECT MONTHS_BETWEEN(CURRENT_DATE, ADD_MONTHS(SYSDATE, 5)) FROM DUAL;

SELECT MONTHS_BETWEEN('30/12/2022', '30/1/2022') FROM DUAL;

SELECT MONTHS_BETWEEN(TO_date('30/12/2022', 'DD-MM-YYYY'),TO_date('30/1/2022', 'DD-MM-YYYY')) FROM DUAL;

--video notes ends here---

Regards
TechView Team