date format issue

[seshikumar]

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

[chulett]

What help do you need? That format *is* 'Oracle format' already and dates like that can be compared directly with no conversions needed.