I want to conver incoming dates in following format dd-Mon-yyyy using data stage function in transformer.
I have used following:
:DateToString(TimestampToDate(in_txfrmValidateRec_proclnk.STG_000_SITE_VISIT_DT),('%dd-%Mmm-%yyyy'))
but job is getting aborted saying the wrong format.
Please suggested me the way.
Is any data stage function for the same?
Use oracle fn will not solve my problem.
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)
Balaram prajapati
+91-9820583531(India,Mumbai)