Converting string to date!!
Moderators: chulett, rschirm, roy
Converting string to date!!
Hi All,
while i was converting from varchar to date i was getting following warning.
Transformer_86,0: Conversion error calling conversion routine date_from_string data may have been lost
and getting ****** as output
By searching the previous posts i tried
input is in format 03/13/2010 and i want in 2010/03/13 format.
StringToDate(Trim(DSLink92.ProcessDate,' ','A'),"%yyyy/%mm/%dd")
but the warning still exists...
Any Suggestions...
while i was converting from varchar to date i was getting following warning.
Transformer_86,0: Conversion error calling conversion routine date_from_string data may have been lost
and getting ****** as output
By searching the previous posts i tried
input is in format 03/13/2010 and i want in 2010/03/13 format.
StringToDate(Trim(DSLink92.ProcessDate,' ','A'),"%yyyy/%mm/%dd")
but the warning still exists...
Any Suggestions...
Re: Converting string to date!!
hi vivek,
trying using OconV & IconV Functions in the transformer
something like ---- Oconv(Iconv("03/13/2010", "D/MDY[2,2,4]"), "D/YMD") in the transformer derivation ..
it should work.
trying using OconV & IconV Functions in the transformer
something like ---- Oconv(Iconv("03/13/2010", "D/MDY[2,2,4]"), "D/YMD") in the transformer derivation ..
it should work.
Madhu Routhu
Re: Converting string to date!!
I was developing job in parallel..
Oconv and Iconv functions are not present in parallel..
thank you..
Oconv and Iconv functions are not present in parallel..
thank you..
You are experiencing a conversion failure of some sort. Either the string coming in will not convert to a date or the format you have defined does not match the data.
Mike Hester
mhester@petra-ps.com
mhester@petra-ps.com
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 06, 2007 10:32 am
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 06, 2007 10:32 am
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 06, 2007 10:32 am
try input using varchar(10) and output as date
derivation : StringToDate(input,"%mm/dd/yyyy%")
If you have nulls coming from source then handle it
Go to output file under columns double click on the left of the output column which will open the edit column meta data window where you can specify the format you want
under datatype - format string(%yyyy/%mm/%dd)
derivation : StringToDate(input,"%mm/dd/yyyy%")
If you have nulls coming from source then handle it
Go to output file under columns double click on the left of the output column which will open the edit column meta data window where you can specify the format you want
under datatype - format string(%yyyy/%mm/%dd)
-
- Premium Member
- Posts: 46
- Joined: Wed Jun 06, 2007 10:32 am