How to use TO_CHAR function to change date format in oracle, VERY USEFUL!! скачать в хорошем качестве

How to use TO_CHAR function to change date format in oracle, VERY USEFUL!!

We usually use this function we we need to change the format of date on oracle sql query. Here is how to change date format in oracle using this function: Chapters: 00:00 Intro 00:39 to_char YYYY example. 01:22 to_char YEAR example. 01:29 to_char MM example. 01:45 to_char MONTH example. 01:51 to_char MON example. 02:00 to_char DY example. 02:09 to_char DAY example. 02:15 to_char DD example. 02:25 to_char hour and minutes HH MI SS example. 03:17 to_char change format with adding words. 03:38 to_char add th to date. 03:55 to_char full example. 04:34 to_char what is fm. ✅ The below is the demonstrated examples on this video: SELECT TO_CHAR (SYSDATE , 'YYYY ' ) FROM DUAL SELECT TO_CHAR (SYSDATE , 'YEAR' ) FROM DUAL SELECT TO_CHAR (SYSDATE , 'MM') FROM DUAL SELECT TO_CHAR (SYSDATE , 'MONTH' ) FROM DUAL SELECT TO_CHAR (SYSDATE , 'MON') FROM DUAL SELECT TO_CHAR (SYSDATE, 'DY' ) FROM DUAL SELECT TO_CHAR (SYSDATE , 'DAY') FROM DUAL SELECT TO_CHAR (SYSDATE , 'DD') FROM DUAL SELECT TO_CHAR (SYSDATE , 'HH24:MI:SS AM') FROM DUAL SELECT TO_CHAR (SYSDATE , 'DD "of" MONTH') FROM DUAL SELECT TO_CHAR (SYSDATE , 'ddspth') FROM DUAL ✅ Full example: SELECT last_name, TO_CHAR(hire_date, 'fmDD "of" Month YYYY') AS HIREDATE FROM employees; ✅ website: https://erpscope.com/ ✅ How to become oracle expert Article: https://erpscope.com/how-to-become-or... ✅ Oracle database download link: https://www.oracle.com/kw/database/te... ✅ To install sample database on you database, please check this video:    • How to install Oracle Sample Database sche...   ✅ linkedin :   / posts   ✅Facebook:   / erpscope   ✅ Twitter:   / erp_scope   ✅Instagram:   / erp_scope