Date value type, value and interval value : Date Time Interval « Date Timezone « Oracle PL / SQL

1. Oracle PL / SQL
2. Date Timezone
3. Date Time Interval

Date value type, value and interval value

 
 
Datetime field      Datetime values                  Interval values      
YEAR               -4712 to 9999 (but not zero)     Any positive or negative integer        
MONTH              1 to 12                          0 to 11        
DAY                1 to 31                          Any positive or negative integer        
HOUR               0 to 23                          0 to 23        
MINUTE             0 to 59                          0 to 59        
SECOND             0 to 59.999999999                0 to 59.999999999        
TIMEZONE HOUR      -12 to 13             
TIMEZONE MINUTE    0 to 59           

 

Related examples in the same category