Oracle PL/SQL/Date Timezone/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     �