Oracle SQL DATE data type

1.It is used to store date type values in oracle format.

2.Oracle is having a predefined date format as follows.

 

           DD-MON-YY  [ 02-nov-19 ]

           DD    -  Digits of date

           MON   -  First 3 chars in month name

           YY    -  Last 2 digits of year

 

§If yy value is between 00 to 49, then year is considered from current century like 2000 to 2049.

§If yy range is from 50 to 99, then year is considered from Previous century like 1950 to 1999.

 

IN Oracle 12c, we can enter a year number completely

02-nov-2019

02-jan-1956

 

Ex:     01-jun-17

Ex:     01/jun/17 --It is not considered as a date format--