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
]
can any one implement this code in datastage
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 15
- Joined: Sun Feb 22, 2009 3:31 pm