Interval的知识点

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements003.htm#SQLRF00221

 

IntervalLiterals

 

An interval literal specifies a period of time. You can specifythese differences in terms of years and months, or in terms ofdays, hours, minutes, and seconds. Oracle Database supports twotypes of interval literals,YEAR TOMONTH and DAY TOSECOND. Each type contains a leading field and maycontain a trailing field. The leading field defines the basic unitof date or time being measured. The trailing field defines thesmallest increment of the basic unit being considered. For example,aYEAR TO MONTH intervalconsiders an interval of years to the nearest month. ADAYTO MINUTE intervalconsiders an interval of days to the nearest minute.

If you have date data in numeric form, then you can use theNUMTOYMINTERVAL orNUMTODSINTERVALconversion function to convert the numeric data into intervalvalues.

Interval literals are used primarily with analyticfunctions.

See Also:

"AnalyticFunctions", NUMTODSINTERVAL, NUMTOYMINTERVAL, and Oracle Data Warehousing Guide

 

INTERVAL YEAR TO MONTH

 

Specify YEAR TO MONTHinterval literals using the following syntax:

interval_year_to_month::=

Description of the illustrationinterval_year_to_month.gif