Time intervals
The data types of Time Intervals stores time intervals. For example, 2 year 1 months, 25 months, -3 days 4 hours 5 minutes, 1 day 2 hours, -100 hours. A time interval stores a length of time, whereas a date or timestamp stores a specific date and time.
| Type | Description |
|---|---|
| INTERVAL YEAR[(years_precision)]TO MONTH | Stores a time interval in years and months. |
| INTERVAL DAY[(days_precision)]TO SECOND[(seconds_precision) | Stores a time interval in days and seconds. |
Home »
Oracle »
Data types »
Oracle »
Data types »
Time_intervals:
- Time intervals
- INTERVAL YEAR TO MONTH
- INTERVAL DAY TO SECOND
Related: