Syntax to Update Timestamp Column

[santhoshv]

Hi,

I have a column with Timestamp data type. Now i need to update the column.
How do i Update the column.

Could anyone send me the syntax??

Thanx in advance !

[FritzLeblanc]

Hi,

I have a column with Timestamp data type. Now i need to update the column.
How do i Update the column.

Could anyone send me the syntax??

Thanx in advance !

Shouldn't be any different from any other column type. Update table_name set timestamp_colum n = current timestamp. if you use a host variable instead of current timestamp, you need to make sure that the host variable contains a properly formatted timestamp value.