DSXchange

Hi Friends,
While changing from timespamp to string i am getting below warning and data showing null, i tried some ways but again and agin showing the same warning, can any one help in this solution.


APT_CombinedOperatorController(0),0: Data string '19971001' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %dd.

Remove the %hh%mm%ss and try to execute

showing same message

gssr wrote:Remove the %hh%mm%ss and try to execute

are you trying to convert "Timestamp to String" or "String to Timestamp"..Can you able to read the data in the Source file??

Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS")

ArndW wrote:Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS") ...

I think he want to convert Timestamp to String ""while convert timespamp to string getting warnings""

from TimestampToString

ArndW wrote:Try "StringToTimeStamp(In.column:" 00:00:00","%YYYY%MM%DD %HH:%NN:%SS") ...

Which function are you using..?
Try this TimestampToString(DATA,[%yyyy-%mm-%dd])

it's not working

gssr wrote:Which function are you using..?
Try this TimestampToString(DATA,[%yyyy-%mm-%dd])

The syntax is wrong. Explain "not working", please and include the error message.

'19971001' is not a Timestamp.

When i use this
TimestampToString(LNK_CONV_TRANS2.SERVICE,"%yyyy-%mm-%dd") in Trnsformer showing below warning


APT_CombinedOperatorController(0),0: Data string '2009-11-01' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the data string has fewer characters than expected.

chulett wrote:'19971001' is not a Timestamp. ...

'2009-11-01' is a Date and cannot be converted to a timestamp they way you are writing it.
Try :

But again, all that presupposes the input is already a timestamp which this isn't. And the formatting mask in the TimestampToString function is what you want the string to look like.