I get the following warning when using string_from_timestamp function in Modify Stage
Input COlumn is "dt" of type timestamp
Output is "dt_1" of type VarChar
Specification is
dt_1:string = string_from_timestamp(dt)
Where do i specify a format string?Documentation is not really helpful
Sequential_File_0: When checking operator: When binding input interface field "sophis_changed_dt1" to field "sophis_changed_dt1": Implicit conversion from source type "string" to result type "string[max=23]": Possible truncation of variable length string.
Actually i guess im losing out on the correct syntax while passing the format string to the function. Not able to get a clue from the document either
I tried
Okay i got it , the timestamp format also has milli seconds, . I changed teh format string , but i still get an error if i specify the format string . Since there are no examples on using parallel functions, im quite clueless
What is the input format? 1900yy Is your input has only 2 digit of Year patetrn. Does your job abort now? What is your source? If it is database, why can't you convert it during extract?
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
The year is 4 digit and picked up from a sybase database via Stored Proc. Since SP is supplied by another team, i cannot change the same. So im trying to use modify stage to change the field data type.
the input data looks like this
"2004-12-20 02:33:01.147"
Output should be same , but as a varchar field, hence im using explicit transformation.
If i do not use the timestamp format string , job gives an output with millisecond information truncated. When i use timestamp format string , i get the error and job aborts , as described in my previous posts. I dont know if im making a syntax mistake in the specification either.