2 Replies Latest reply on Jul 1, 2020 3:59 AM by AMAR LOKESWAR KODATALA

    Date conversion

    AMAR LOKESWAR KODATALA Active Member

      Hi,

       

      I have date in format YYYY-MM-DD HH24:MM:SS.MS(EX: 2016-06-25 23:34:22.123456000)  that needs to converted to YYYY-MM-DD HH:MM:SS. Used below expression its not working

       

       

      1.TO_DATE(SUBSTR(TO_CHAR(prq_entry_tmestmp_in), 0,18), 'YYYY-MM-DD HH:MM:SS')

      2. TO_DATE(TO_CHAR(SUBSTR(TO_CHAR(prq_entry_tmestmp_in), 0,18),'YYYY-MM-DD HH:MM:SS'))