DSXchange

Hi all,
I'm converting string to timestamp.
My source : 2011-29-08 05:28:51
Conversion format: StringToTimestamp(sd2,"%yyyy-%mm-%dd %hh:%nn:%ss")

Warning that I'm getting is:

Data string '*******************' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected.

I have gonethrough the forums. But I didnt get solution for my problem.

Can anyone help me?

Regards,

This is the same thing you asked in this thread: viewtopic.php?t=142244 . Why are you posting it again and under a topic heading that is totally misleading?

did you check the default timestamp in your project

The base is, you need to pass how the data is coming and not how the data you need as the output.

You have YDM as the input whereas you passed as YMD.

In your previous post itself you have the answer. Dont expect the ans as it is. Come out from the issue and find what is wrong and what need to be the solution rather than fix the problem. This will help you to handle the issue rather than just solving for this time!

DS User

What is the datatype of the source you are trying to convert? If it's a string, where did it come from? My guess is that it came from another timestamp, or date or time...

Regards,

Mark,
The issue you have highlighted is different from what I have asked now.
There I had problem in inserting timestamp to SQL server.
But here I'm receiving timestamp as string as per Datastage format. But I'm not able to view the data if I convert this string to timestamp.

MarkB wrote:This is the same thing you asked in this thread: viewtopic.php?t=142244 . Why are you posting it again and under a topic heading that is totally misleading?

SURA wrote:You have YDM as the input whereas you passed as YMD.

Thanks Sura,
I don't know, How did I miss this?
Its working fine.

Sometimes all it takes is another pair of eyes.