DateToString format "dd-Mon-yyyy"
Posted: Thu Jul 24, 2008 9:26 am
Hi
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.
Balaram prajapati
+91-9820583531(India,Mumbai)
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.
Balaram prajapati
+91-9820583531(India,Mumbai)