Hi ,
I am getting Following warning while converting data in string format to date
Transformer :Conversion error calling conversion routine date_from_string data may be lost
The String Length is 8(e.g. 20341221),and I used the StingToDate function and got the output 2034-12-21 but with warnings...
What should be the appropiate Date datatype Length and how i can suppress above warning??
Datatype Conversion Warning.....from StringToDate
Moderators: chulett, rschirm, roy
Can you post the exact derivation from the Transformer stage you have used? It should be
Code: Select all
StringToDate(InputLink.Column, "%yyyy%mm%dd")
Kris
Where's the "Any" key?-Homer Simpson
Where's the "Any" key?-Homer Simpson
Thanks for quick response..."Kris007"kris007 wrote:Can you post the exact derivation from the Transformer stage you have used? It should be
Code: Select all
StringToDate(InputLink.Column, "%yyyy%mm%dd")
I used the following derivation
i actually want Date in dd-mm-yyyy format can anyone specify the derivationStringToDate(DDate [1,4] : "-" : DDate [5,2] :"-" : DDate [7,2],"%yyyy-%mm-%dd")
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Dates aren't "in" any particular kind of format. It's only when they are converted to string that format becomes important. Having created a date, as in this thread, you can then apply a DateToString() function and specify an explicit date picture such as "%dd-%mm-%yyyy".
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.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia