I need to update a column in my table based on the system timestamp - 30 days.
the column is defined as varchar(50)
and when I select the values from the column I get the output as
there is another column called 'compliant' which is defined as number and takes a binary value 1 or 0
I need to set this column to 1 if the timestamp in the varchar column is current_date- 30
I tried this ---
set iscompliant = 1
where to_timestamp(lastupdatetime,'YYYY-MM-DD 24HH:MM:SS') = current_date - 30
and I get this error --
SQL Error: ORA-01841: (full) year must be between -4713 and +9999, and not be 0
01841. 00000 - "(full) year must be between -4713 and +9999, and not be 0"
*Cause: Illegal year entered
*Action: Input year in the specified range
how do I fix this issue??