The system function
DateTimeLib.extend converts
a timestamp, time, or date into a longer or shorter timestamp value. Examples
are as follows:
- If you have an input timestamp defined as "ddHH" (day and hour) and provide
a timestamp mask of "ddHHmm" (day, hour, and minute), DateTimeLib.extend returns
an extended value that matches the mask
- If you have an input timestamp defined as "yyyyMMddHHmmss" (year, month,
day, hour, minute, and second) and provide a timestamp mask "yyyy"
(year), DateTimeLib.extend returns a shortened value that matches the
mask
DateTimeLib.extend(
extensionField dateOrTimeOrTimeStamp in
[, mask outputTimeStampMask in
])
returns (result TIMESTAMP)
- result
A variable of type TIMESTAMP.
- extensionField
The name of a field of type TIMESTAMP, TIME, or DATE. The field contains
the value to be extended or shortened.
- mask
- A string literal or constant that defines the mask of the timestamp value
returned by the function. For details, see TIMESTAMP.