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,
Not able to view the out put in sequential file
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
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?
Re: Not able to view the out put in sequential file
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
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
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
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.
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?
Ajitha S
-
- Participant
- Posts: 75
- Joined: Mon Jul 12, 2010 4:11 am
- Location: Chennai
Re: Not able to view the out put in sequential file
Thanks Sura,SURA wrote:You have YDM as the input whereas you passed as YMD.
I don't know, How did I miss this?
Its working fine.
Ajitha S