Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

INTERVAL includes two datatypes that allow you to set appropriate durations more precisely

declare     variable1_int INTERVAL YEAR[(precision)] TO MONTH; begin     NULL; end; The INTERVAL YEAR TO MONTH datatype allows you to store and manipulate intervals of years and months. You can specify the number of digits in years that you want to store (by default 2, available range is 0?). INTERVAL DAY declare     variable2_int INTERVAL DAY[(precision)] to SECOND[(precision)]; begin     NULL; end; The INTERVAL DAY TO SECOND datatype allows you to store and manipulate intervals of days, hours, minutes, and seconds. In this case, day precision allows you to set the number of digits you want to store, and second precision identifies the number of digits used to store fractions of seconds.