Hi,
I am trying to update the timestamp into a table like this:
Update tablea set status = 'Succeeded', end_date = cast(cast(current_timestamp(0) as format 'dd/mm/y4bhh:mi:ss') as char(19)) where id = 3456;
I am getting Invalid timestamp for this query. When I check the timestamp data through select it looks like this:
select cast(cast(current_timestamp(0) as format 'dd/mm/y4bhh:mi:ss') as char(19))
Resultset:27/10/2009 02:56:12
I want to update the end_date through current_timestamp not by putting timestamp value in it.
Please help me in this. Thanks and Regards, TDHelp