while convert timespamp to string getting warnings

[deesh]

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.

[gssr]

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

[deesh]

showing same message

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

[gssr]

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

[ArndW]

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

[gssr]

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""

[deesh]

from TimestampToString

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

[gssr]

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

[deesh]

it's not working

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

[ArndW]

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

[chulett]

'19971001' is not a Timestamp.

[deesh]

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.

'19971001' is not a Timestamp. ...

[ArndW]

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

Code: Select all

TimestampToString(LNK_CONV_TRANS2.SERVICE:' 00:00:00',"%yyyy-%mm-%dd %hh:%nn:%ss")

[chulett]

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.