hire date from timestamp to date


create or replace procedure p1(v_empno number)
as
v_eno number;
v_ename varchar(10);
v_hiredate1 date;
v_hiredate2 timestamp;
begin
select empno,ename,hiredate
into
v_eno,v_ename,v_hiredate2
from emp1
where empno=v_empno;
v_hiredate1:=v_hiredate2;
insert into emp1_tgt values(v_eno,v_ename,v_hiredate1);
end;
/

SQL> select * from emp1;

     EMPNO ENAME      HIREDATE
---------- ---------- --------------------------------
         1 ram        12-JAN-07 12.00.00.000000 AM

SQL> select * from emp1_tgt;

     EMPNO ENAME      HIREDATE
---------- ---------- ---------
         1 ram        12-JAN-07