Help in rectifying Pivot Warning

[mac4rfree85]

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!!!!!!!!

[ray.wurlod]

You only have a time, not a timestamp.

[mac4rfree85]

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")