Please enable JavaScript to view this site.

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.