DSXchange

Hi All,

I want to change a string value (2009-12-13 10:10:25 ) to Timestamp(13/12/2009 10:10:25)

I tried StringtoTimestamp(Input,,"%dd/%mm/%yyyy %hh:%nn:%ss").

But this conversion function is not giving desired output for me.

Please Advise.

Thanks,
Kumar66

You specified the delimiter incorrectly. It must be precisely specified.

Hi Ray,

Thanks for your input. I tried , but it gives the follwoing error:

Data string '2009-12-13 08:57:45' does not match format '%dd-%mm-%yyyy %hh:%nn:%ss': the value for tag %mm has fewer characters than expected.

Please Advise.

Thanks,
Kumar66

Read the error message in detail and change your format to:

StringtoTimestamp(Input,,"%yyyy-%mm-%dd %hh:%nn:%ss")

Timestamps have no external format, the mask in the function must match what is coming in in the string field, not what you think it should look like.

i agree with what chulett said , i also was confused about that before , but now take it as a rule , the mask for the function is telling the function how the input is passed to you and further the function understand the input to manipulate it

kumar66 wrote:Data string '2009-12-13 08:57:45' does not match format '%dd-%mm-%yyyy %hh:%nn:%ss'

That is precisely correct.

Just look at it!

Then proceed as Arnd advised.