The DATETIME function returns the current date and time.
Category
Date / Time
Syntax
DAY(date)
Parameter and Description
| Parameter | Description |
|---|---|
| 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.