DSXchange

Posted: **Fri Aug 26, 2011 3:34 am**

Hi Guys,

Altogether i am pivoting 7 columns. One of the column is a Timestamp Column.
Because of the Timestamp column pivoting, i am getting this Warning.

Code: Select all

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.

If I remove the Timestamp pivot, then i am not getting Warning.
In our project, we do not suppress warning. Is there anyway we can rectify this warning?

It would very helpful if you can throw some light on this.

Cheers!!!!!!!!

Posted: **Fri Aug 26, 2011 5:45 am**

You only have a time, not a timestamp.

Posted: **Sat Aug 27, 2011 3:26 am**

There is no time field. There is only one Timestamp column. I also checked the timestamp column, i did not find such a data ("00:00:00")

DSXchange

Help in rectifying Pivot Warning

Help in rectifying Pivot Warning