StringToTimestamp err
Moderators: chulett, rschirm, roy
StringToTimestamp err
I am trying to using this function StringToTimestamp(DSLink8.Eff_date,%yyyy-%mm-%dd %hh:%nn:%ss)
DSLink8.Eff_date this is a string.I dont mind if the timepart is default.
Transformer_7,2: Conversion error calling conversion routine timestamp_from_string data may have been lost
I searched red the documentation can t seem to fix this.
Thanks
DSLink8.Eff_date this is a string.I dont mind if the timepart is default.
Transformer_7,2: Conversion error calling conversion routine timestamp_from_string data may have been lost
I searched red the documentation can t seem to fix this.
Thanks
EFX
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Did you do
OR
Code: Select all
StringToTimestamp(DSLink8.Eff_date,"%yyyy-%mm-%dd %hh:%nn:%ss")
Code: Select all
StringToTimestamp(DSLink8.Eff_date,%yyyy-%mm-%dd %hh:%nn:%ss)
My job is seq file -> tx -> or db table.
DSLink8.Eff_date looks like this 2/3/2009.I am trying to use stringtotimestamp function in the transformer.My time part in the timestamp can be default.I tried various combination as the sainath suggested but still i get the same warning. I am on 7.5.1a
Thanks
DSLink8.Eff_date looks like this 2/3/2009.I am trying to use stringtotimestamp function in the transformer.My time part in the timestamp can be default.I tried various combination as the sainath suggested but still i get the same warning. I am on 7.5.1a
Thanks
EFX
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
here is what you need to do ..efxuser wrote:My job is seq file -> tx -> or db table.
DSLink8.Eff_date looks like this 2/3/2009.I am trying to use stringtotimestamp function in the transformer.My time part in the timestamp can be default.I tried various combination as the sainath suggested but still i get the same warning. I am on 7.5.1a
Thanks
Code: Select all
StringToTimestamp('2/3/2009',"%(d,s)/%(m,s)/%yyyy")
I tried the suggestions. ->
For StringToTimestamp('2/3/2009',"%(d,s)/%(m,s)/%yyyy") , I got the below warning.
Transformer_7,1: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%(d,s)/%(m,s)/%yyyy" for conversion "timestamp=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss](string)": APT_Conversion_String_TimeStamp: Invalid Format [%(d,s)/%(m,s)/%yyyy] used for string_from_time type conversion.
the format StringToTimestamp(DSLink8.Eff_date:' 00:00:00',"%mm/%dd/%yyyy %hh:%nn:%ss") gave my initial warning also.
For StringToTimestamp('2/3/2009',"%(d,s)/%(m,s)/%yyyy") , I got the below warning.
Transformer_7,1: Caught exception from runLocally(): APT_ParseError: Parsing parameters "%(d,s)/%(m,s)/%yyyy" for conversion "timestamp=timestamp_from_string[%yyyy-%mm-%dd %hh:%nn:%ss](string)": APT_Conversion_String_TimeStamp: Invalid Format [%(d,s)/%(m,s)/%yyyy] used for string_from_time type conversion.
the format StringToTimestamp(DSLink8.Eff_date:' 00:00:00',"%mm/%dd/%yyyy %hh:%nn:%ss") gave my initial warning also.
EFX
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Code: Select all
StringToTimestamp(DSLink8.Eff_date:' 00:00:00',"%m/%d/%yyyy %hh:%nn:%ss")
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
Re: My version is 7.5.1.A
[quote="efxuser"]My version is 7.5.1.A[/quote]
may be someone else with your version has to chime in ...
may be someone else with your version has to chime in ...
-
- Participant
- Posts: 152
- Joined: Tue Jan 13, 2009 8:59 am
Re: My version is 7.5.1.A
"repost"
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom