Скачать или смотреть | TO_CHAR() Function in Oracle | Oracle TO_CHAR() | Get values from Date as per the specified Format

Please subscribe my channel and don't forget to Click the Bell Icon

We will see the Various Uses of To_Char Function by giving various format

Scripts Given Below
--------------------------------
SELECT to_char(sysdate,'DD-MM-YYYY')"DD-MM-YYYY" FROM DUAL;
SELECT to_char(sysdate,'DD-MM-YYYY HH24:MI:SS PM')"DD-MON-YYYY HH24:MI:SS" FROM DUAL;
SELECT to_char(sysdate,'DAY-MON-YYYY')"DAY-MON-YYYY" FROM DUAL;
SELECT to_char(sysdate,'DAY - MONTH - YEAR')"DAY-MONTH-YEAR" FROM DUAL;
SELECT to_char(sysdate,'Q')"QUARTER" FROM DUAL;
SELECT to_char(sysdate,'WW')"WEEK OF YEAR" FROM DUAL;
SELECT to_char(sysdate,'W')"WEEK OF MONTH" FROM DUAL;
SELECT to_char(sysdate-1,'D')"DAY OF WEEK" FROM DUAL;
SELECT to_char(sysdate,'DDD')"DAY OF YEAR" FROM DUAL;
SELECT to_char(sysdate,'DY')"DAY ABBREVIATION" FROM DUAL;
SELECT to_char(sysdate,'RM')"ROMAN NUMERAL MONTH" FROM DUAL;
SELECT to_char(sysdate,'J')"JULIAN DATE" FROM DUAL;

LIKE THE FACEBOOK PAGE -   / oracle-tutorials-108483330680405  
FOLLOW ON Instagram -   / nihar8308  
FOLLOW ON LinkedIn - https://www.linkedin.com/company/orac...
FOLLOW ON TWITTER -   / niharra59094760  

Email Id: [email protected]
Phone No- 8018319781

#TO_CHAR_Function_uses
#Oracle_SQL_PLSQL_Concept
#Oracle_Function