Get Only Time Stamp From Date

Select to_char(:P_DATE,'HH24:MI AM') from dual

Select to_char(sysdate,'HH24:MI AM') from dual

Select to_char(:P_DATE,'HH24:MI:SS AM') from dual

Select to_char(sysdate,'HH24:MI:SS AM') from dual