Error 5407 Inserting into a timestamp column

[GerardMcL]

Hi,

I am running a proc in which an INSERT .. SELECT is fired off.

One of the columns I am inserting to is of type TIMESTAMP.
The value I am inserting is
CAST(CURRENT_TIME(2) AS TIMESTAMP(2))

But I keep getting an error back
SPL1027:E(L282), Missing/Invalid SQL statement'E(5407):Invalid operation on an ANSI Datetime or Interval value.'.

Does anyone know why this is occurring.

Thank You,
Gerard.

 

[GerardMcL]

Doesnt matter got it sorted.

Thanks anyway.