Forum Stats

  • 3,872,900 Users
  • 2,266,488 Discussions
  • 7,911,374 Comments

Discussions

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

User_VBYTP
User_VBYTP Member Posts: 2 Red Ribbon
edited Sep 13, 2022 3:39PM in SQL & PL/SQL

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.

Answers