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)
DateToString format "dd-Mon-yyyy"
Moderators: chulett, rschirm, roy
It might be easiest to take this step-by-step with an example. What is a value and datatype of the input value?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Firstly i doubt that month format mmm will work. Second the timestamp format is wrong. Third the syntax is wrong. If you are using the derivation in transformer, it will change the color to red indicating wrong derivation. And i doubt it would compile. The timestamp format will be something like '%dd-%mm-%yyyy %hh:%mm:%ss' depending on the input format. So pasting a sample record here will help. Also copy paste the exact derivation here, instead of typing.
"given enough eyeballs, all bugs are shallow" - Eric S. Raymond
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Don't use a capital "M" in the format string. Use "%dd-%mmm-%yyyy" as the format string. Note, however, that this format string is not applicable if the day number is a single digit; you may need to check for this possibility.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.