StringToTimestamp err

efxuser · Post by **efxuser** » Tue Mar 03, 2009 3:21 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Mar 03, 2009 3:25 pm

Please give some examples of the content in DSLink8.Eff_date field.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Mar 04, 2009 3:09 am

Did you do

Code: Select all

StringToTimestamp(DSLink8.Eff_date,"%yyyy-%mm-%dd %hh:%nn:%ss")

OR

Code: Select all

StringToTimestamp(DSLink8.Eff_date,%yyyy-%mm-%dd %hh:%nn:%ss)

efxuser · Post by **efxuser** » Wed Mar 04, 2009 8:11 am

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

bart12872 · Post by **bart12872** » Wed Mar 04, 2009 8:28 am

try
StringToTimestamp(DSLink8.Eff_date:' 00:00:00',"%mm/%dd/%yyyy %hh:%nn:%ss")

betterthanever · Post by **betterthanever** » Wed Mar 04, 2009 8:36 am

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

here is what you need to do ..

Code: Select all

StringToTimestamp('2/3/2009',"%(d,s)/%(m,s)/%yyyy")

efxuser · Post by **efxuser** » Wed Mar 04, 2009 8:41 am

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.

betterthanever · Post by **betterthanever** » Wed Mar 04, 2009 8:44 am

efxuser,

i dont know if something to do with the version youa re using, but tested on 8.0.1 version before i posted it.
and it works!!!!

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Mar 04, 2009 8:46 am

Code: Select all

StringToTimestamp(DSLink8.Eff_date:' 00:00:00',"%m/%d/%yyyy %hh:%nn:%ss")

Or simply to a StringToDate and use it as a date.

betterthanever · Post by **betterthanever** » Wed Mar 04, 2009 8:50 am

[quote="Sainath.Srinivasan"][code]StringToTimestamp(DSLink8.Eff_date:' 00:00:00',"%m/%d/%yyyy %hh:%nn:%ss") [/code]

Or simply to a StringToDate and use it as a date.[/quote]

the one sainath suggested also works. i tested it.

efxuser · Post by **efxuser** » Wed Mar 04, 2009 8:58 am

My version is 7.5.1.A

betterthanever · Post by **betterthanever** » Wed Mar 04, 2009 9:16 am

[quote="efxuser"]My version is 7.5.1.A[/quote]

may be someone else with your version has to chime in ...

betterthanever · Post by **betterthanever** » Wed Mar 04, 2009 9:17 am

"repost"

bart12872 · Post by **bart12872** » Wed Mar 04, 2009 9:20 am

not very elegant but still works

StringToTimestamp(Right('0':Field(DSLink8.Eff_date,'/',1),2):'/':Right('0':Field(DSLink8.Eff_date,'/',2),2):'/':Field(DSLink8.Eff_date,'/',3) :' 00:00:00',"%mm/%dd/%yyyy %hh:%nn:%ss")

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Mar 04, 2009 9:21 am

The format must not be dependant on the version.

DSXchange