Skip to Main Content
Forums

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!

YYYY-MM-DD"T"HH:MM:SS.SSS to YYYY/MM/DD HH24:MI:SS

Rajesh123Jul 5 2019 — edited Jul 7 2019

Hi All,

attribute17 is varchar2 and having value like 2019/03/14 00:00:00

select to_date(attribute17,'YYYY/MM/DD HH24:MI:SS') from dual;

But in EBS Bi publisher in data XML displaying: like below.

<attribute17>2019-03-14T00:00:00.000-04:00</attribute17>

But i need this format: YYYY/MM/DD HH24:MI:SS

Oracle 11.2.0.4.0
Comments
Post Details
Added on Jul 5 2019
9 comments
38,342 views