DAY |
Scroll |
The DAY function returns the day portion of a source date.
Category
Date / Time
Syntax
DAY(date)
Parameter Descriptions
date - This parameter specifies a source date in YYYYMMDD format.
Example
Extract the day portion of a date of 11/27/2000 and map the result to target field TGT_DAY.
TGT_DAY = DAY (20001127)
Returns the value of 27.