Скачать или смотреть Just know the Alter session date formats in oracle - Cool Videos

Now you guys are known, how to use date formats clearly!
Select sysdate from dual;
Alter session set nls_date_format= 'yyyy-dd-MM HH24:MI:SS'
Alter session set nls_date_format = 'HH24'; Hour of day of 24.
Alter session set nls_date_format = 'HH'; Hour of day (1-12).
Alter session set nls_date_format = 'MON'; Short form of months.
Alter session set nls_date_format ='MONTH'; Full form of months.
Alter session set nls_date_format = 'DD'; It gives what live day.
Alter session set nls_date_format = 'MM'; Months in numbers.
Alter session set nls_date_format = 'DY'; what is the day today!
Alter session set nls_date_format = 'YYYY' full 4 digits of year.
Alter session set nls_date_format = 'yy'; last two digits of year.
Alter session set nls_date_format = 'AM'; whatever you give there!it gives live am or pm.
Alter session set nls_date_format = 'MI'; what minutes in live time.
Alter session set nls_date_format = 'SS'; what seconds in live time.
Alter session set nls_date_format= 'yyyy-dd-MM HH24:MI:SS'
-------------------------------------------------------------------------------------------
Check my pervious video if you don't understand clearly!
I covered some basic topics in oracle!
   • Just know How to Create a Very Very Basic ...