i am getting 2 source colums JOB_EFFECTIVE_DATE,EMP_STATUS_EFFECTIVE_DATE(timestamp) from sequential file.
format like 2007-08-17 00:00:00 so i need to compare the dates
if JOB_EFFECTIVE_DATE >=EMP_STATUS_EFFECTIVE_DATE then JOB_EFFECTIVE_DATE else EMP_STATUS_EFFECTIVE_DATE
my target is oracle timestamp format like YYYY-MM-DD HH24:MI:SS so i need to store this value my oracle target table
anyone can help me
date format issue
Moderators: chulett, rschirm, roy