DSXchange

Hi friends-----------
Help in finding the last_day of the month form a time stamp in a datastage.( here take the help of this code).

[/CASE
WHEN PS_D_DAY.MONTH_YR_NUM BETWEEN 1 AND 3 THEN
PS_D_DAY.DAY_YR_NUM
WHEN PS_D_DAY.MONTH_YR_NUM BETWEEN 4 AND 6 THEN
PS_D_DAY.DAY_DT - TO_DATE( '01-04-' || TO_CHAR(PS_D_DAY.YEAR_NUM), 'DD-MM-YYYY' ) + 1
WHEN PS_D_DAY.MONTH_YR_NUM BETWEEN 7 AND 9 THEN
PS_D_DAY.DAY_DT - TO_DATE( '01-07-' || TO_CHAR(PS_D_DAY.YEAR_NUM), 'DD-MM-YYYY' ) + 1
WHEN PS_D_DAY.MONTH_YR_NUM BETWEEN 10 AND 12 THEN
PS_D_DAY.DAY_DT - TO_DATE( '01-10-' || TO_CHAR(PS_D_DAY.YEAR_NUM), 'DD-MM-YYYY' ) + 1
ELSE
0
END
]

I don't see what this SQL has to do with getting the "last day of the month", nevermind the fact that Oracle (which this looks to be) has a built-in function for that.