Oracle Fusion BIP
TO_DATE(accountion_date, 'RRRR/MM/DD HH24:MI:SS')
TO_DATE(TO_CHAR(accountion_date, 'RRRR/MM/DD HH24:MI:SS'),'RRRR/MM/DD HH24:MI:SS')
TO_CHAR( TO_DATE(accountion_date, 'RRRR/MM/DD HH24:MI:SS'),'DD-MM-YYYY')
TO_DATE(nvl(:P_FROM_Period,TO_CHAR(ail.accountion_date, 'RRRR/MM/DD HH24:MI:SS')),'RRRR/MM/DD HH24:MI:SS')