TimeStamp
Moderators: chulett, rschirm, roy
TimeStamp
Hi All,
getting this error for Time stamp. CAn any one help in this
ValidateAndSplit,3: Invalid value for this date type: **********.
Invalid value for this date type: **********.
Invalid value for this date type: **********.
Gul
getting this error for Time stamp. CAn any one help in this
ValidateAndSplit,3: Invalid value for this date type: **********.
Invalid value for this date type: **********.
Invalid value for this date type: **********.
Gul
Re: TimeStamp
Could u tell us what's ur input and what manipulations were u attempting which resulted in the error???
A printer consists of 3 main parts: the case, the jammed paper tray and the blinking red light.
Gul,
lots of people here could help if we knew more. You are seeing and showing us the text representation of an invalid TimeStamp value. What is the last stage where the TimeStamp was (verifiably) correct and what did you do to it thereafter?
lots of people here could help if we knew more. You are seeing and showing us the text representation of an invalid TimeStamp value. What is the last stage where the TimeStamp was (verifiably) correct and what did you do to it thereafter?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
If JoinCombine_Master_Ref.TrailerTimeStamp is a string datatype with the YYYY-MM-DD format, then I recommend using the simpler
Code: Select all
StringToTimestamp(JoinCombine_Master_Ref.TrailerTimeStamp:" 00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss")
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
And what have you tested, gshivnani?
I trust you didn't post first before trying to localize the problem.
I just wrote a short job, column generator creating a varchar(32) string with the constant value "2005-10-01" and a transform stage using the StringToTimestamp conversion and it worked.
As I indirectly asked in the previous post, is your JoinCombine_Master_Ref.TrailerTimeStamp column a string type?
I trust you didn't post first before trying to localize the problem.
I just wrote a short job, column generator creating a varchar(32) string with the constant value "2005-10-01" and a transform stage using the StringToTimestamp conversion and it worked.
As I indirectly asked in the previous post, is your JoinCombine_Master_Ref.TrailerTimeStamp column a string type?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
And what is the format of this Varchar? Is it YYY-MM-DD?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You already posted the format you thought it was in, but I asked what the data for this column actually contains. If it contains any format except YYYY-MM-DD in your varchar (even extraneous spaces count against you) then you are going to get an error.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>