PowerCenter
- PowerCenter 10.5
- All Products
LAST_DAY(date)
Argument
| Required/
Optional
| Description
|
---|---|---|
date
| Required
| Date/Time datatype. Passes the dates for which you want to return the last day of the month. You can enter any valid transformation expression that evaluates to a date.
|
LAST_DAY( ORDER_DATE )
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
LAST_DAY( TO_DATE( ORDER_DATE, 'DD-MON-YY' ))
|
|
---|---|
|
|
|
|
|
|
|
|