DataStage Support Oracles DDSPTH
Posted: Tue Dec 24, 2002 4:57 am
Hi All,
Merry Christmas.
Assume I have a Date 25-OCT-2002.I require the Output as
"Twenty fifth October Two Thousand Two".Which DSFunction has to be used in DataStage to get the above output.
If I need the same result in oracle.I will use the follwing Function.
Select sysdate,to_char(sysdate,'DDSPTH FMMONTH YEAR') From dual.
Where To_Char Format mask ('DDSPTH FMMONTH YEAR') will give me desired output.
Thanks in Advance,
T Sankar & K S Rajan
Merry Christmas.
Assume I have a Date 25-OCT-2002.I require the Output as
"Twenty fifth October Two Thousand Two".Which DSFunction has to be used in DataStage to get the above output.
If I need the same result in oracle.I will use the follwing Function.
Select sysdate,to_char(sysdate,'DDSPTH FMMONTH YEAR') From dual.
Where To_Char Format mask ('DDSPTH FMMONTH YEAR') will give me desired output.
Thanks in Advance,
T Sankar & K S Rajan