Oracle DATE to Datastage Timestamp
select to_char(PUBLISHENDTIME, 'YYYY-MM-DD HH24:MI:SS')
from S_131940_TTI_EVENT
where rownum < 100