Getting the sysdate- error in pl/sql
Hi,
I am trying to get the sysdate and insert the value in table:
declare
v_tutor_id number;
v_start_time timestamp;
begin
select tutor_id, start_time into v_tutor_id,v_start_time
from ICSAD_SESSION_STEP;
v_start_time:= to_char(sysdate,'yyyy/mm/dd');
end;
I am getting following error:
ORA-06550: line 5, column 24: PLS-00488: 'SYSDATE' must be a type ORA-06550: line 5, column 24: PL/SQL: Item ignored
Any help is highly regarded.