A duration is a value that represents a time interval. There are three kinds of duration:
A labeled duration represents a specific unit of time as expressed by a value expression followed by a duration keyword. Labeled duration appears in syntax as labeled-duration. For expanded labeled-duration syntax, see Expansion of Labeled-duration.
These are examples of labeled durations:
A date duration is a value of data type DECIMAL(8,0) that represents an interval of years, months, and days. The value must have the format yyyymmdd where yyyy represents the number of years, mm the number of months, and dd the number of days.
For example, the date duration 41027 represents 4 years, 10 months, and 27 days.
A time duration is a value of data type DECIMAL(6,0) that represents an interval of hours, minutes, and seconds. The value must have the format hhmmss where hh represents the number of hours, mm the number of minutes, and ss the number of seconds.
For example, the time duration 173306 represents 17 hours, 33 minutes, and 6 seconds.
|
Copyright © 2014 CA.
All rights reserved.
|
|