- YEAR : any integer (+, -)
- MONTH : 0 ~ 11
- DAY : any integer (+, -)
- HOUR
- MINUTE
- SECOND
select current_date
, current_date
+ interval '10-2' year to month
+ interval '10 2:35:17' day to second
from dual;
----------------
'Oracle > SQL Fundamentals II' 카테고리의 다른 글
| 14일차 # 5-25: EXTRACT ( ... FROM ... ) (0) | 2012.04.23 |
|---|---|
| 14일차 # Example (0) | 2012.04.23 |
| 14일차 # 5-18: INTERVAL data types (0) | 2012.04.23 |
| 14일차 # 5-12: TIMESTAMP Fields (0) | 2012.04.23 |
| 14일차 # 5-10: Timestamp Data Type (0) | 2012.04.23 |