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!

displaying YYYY-MM-DDT00:00:00.000-05:00 but need mm/dd/yyyy hh24:mi:ss

Rajesh123May 23 2018 — edited Aug 14 2018

Hi All,

I have check_date column which is having mm/dd/yyyy hh24:mi:ss while i am exporting into excel.

But i am getting 2023-01-18T00:00:00.000-05:00 date format and i need mm/dd/yyyy hh24:mi:ss ,could you please help me on this?

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

This post has been answered by Rajesh123 on May 23 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2018

Added on May 23 2018

7 comments

1,696 views