Hi,
I am trying to export the transponder numbers of the employees. For this I also need the employee's entry date and exit date. For this I have to write a select statement which reads the date.
(Select eep.date_of_employment
from IFSAPP.EMP_EMPLOYED_TIME_ROW eep
where eep.emp_no = tp.emp_no
and eep.date_of_leaving > sysdate)
This works very well in PL/SQL Developer. If I use this select statement in the migration job and use VARCHAR2 as datatype the date fields are also DD.MM.YY. If I use DATE as datatype the job runs into an error and nothing is exported.
What am I doing wrong?
Regards
André