SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Trying to Convert YYYY-MM-DDTHH:MI:SS to MM-DD-YYYY HH24:MI

User_VBYTPSep 13 2022 — edited Sep 13 2022

I am trying to Convert this Date format(YYYY-MM-DDTHH:MI:SS) to MM-DD-YYYY HH24:MI (Should be Date)
I have used CAST((FROM_TZ(CAST("DATE_FIELD" AS TIMESTAMP),'+00:00') AT TIME ZONE 'US/Eastern') AS DATE) and when I try to convert into this format it gives me error : ORA Exception.I can use TO_Char but here is condition that field should be in Date format.