LAST_DAY( date )

Example : The following expression returns the last day of the month for each date in the ORDER_DATE port.

LAST_DAY( ORDER_DATE )            Return value
Apr 1 1998 12:00:00AM                 Apr 30 1998 12:00:00AM
Jan 6 1998 12:00:00AM                 Jan 31 1998 12:00:00AM

Example : The following expression returns the first day of the month for each date in the ORDER_DATE port.

ADD_TO_DATE(ADD_TO_DATE(LAST_DAY( ORDER_DATE ),'MM',-1),'DD',1)
ORDER_DATE                         Return value
Apr 1 1998 12:00:00AM                 Apr 1 1998 12:00:00AM
Jan 6 1998 12:00:00AM                 Jan 1 1998 12:00:00AM