Timestamp issue when using Pivot Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
Timestamp issue when using Pivot Stage
I am converting rows into columns so am using pivot stage. But while doing that am getting below warning for timestamp field. When I run the job without Pivot stage am not getting this warning. So it is something to do with Pivot stage. Can anyone give an advise as to how this warning could be resolved.
Warning is as below.
Data string '00:00:00' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the value for tag %yyyy has fewer characters than expected.
Warning is as below.
Data string '00:00:00' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': the value for tag %yyyy has fewer characters than expected.
Sandeep Chandrashekar
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
Re: Timestamp issue when using Pivot Stage
According to the quoted warning, you only passed the time part.Sandeepch19 wrote:Warning is as below.
Data string '00:00:00'
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
Re: Timestamp issue when using Pivot Stage
When I checked in google I came across one solution where we need to update some patch because there is an issue with Pivot Stage in handling TimeStamp.
Sandeep Chandrashekar
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
Fix your issue? You may think you are appending that zero time to a date but the error message says you are not, so I would ensure your dates are always valid before you add the time as all it takes is one bad apple to cause that message.
If you are sure everything you are doing is fine, contact support and see if there is even such a patch.
If you are sure everything you are doing is fine, contact support and see if there is even such a patch.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
-
- Participant
- Posts: 36
- Joined: Fri May 21, 2010 12:40 am
- Location: Bangalore
My Date Validation Logic is like this
Code: Select all
If INDATE <> "" Then
If IsValid('Date', INDATE[1,4] : "-" : INDATE[5,2] : "-" : INDATE[7,2]) = 1 Then
StringToDate(INDATE,"%yyyy%mm%dd")
Else SetNull()
Else SetNull()
Sandeep Chandrashekar