SQL & PL/SQL

Hi



I apologize if this has been answered before but I'm quite new to PL/SQL and I have come to a small problem.

We are using Timestamp(6) for our date columns and when performing updates on these via Update statments I get a warning when I compile. I understand why as I am updating a timestamp column with a systimestamp that contains timezone information. Is there a way of updating timestamp columns with the systimestamp value without having compile warnings?

I have tried using cast(systimestamp as timestamp(6)) in the update statement to no avail, the only way around this I have found is to place the systimestamp into a timestamp type variable then use that in an update statement, I'm not sure this is the right way to do thins hence the question.

Thank you Vicky

Edited by: user10090654 on 06-Nov-2008 03:15