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"HH24:MI:SS.ff3"Z time stamp in oracle SQL

Rajesh123Jan 12 2017 — edited Jan 12 2017

Hi All,

select '2009-03-13T00:00:00.000-07:00' from dual

date data type and i need to print DD-MON-YY

Ex: 13-MAR-09

I have tried with this

select to_char(to_date(to_date(SUBSTR('2009-03-13T00:00:00.000-07:00',1,10),'YYYY-MM-DD'),'DD-MON-YY')) from dual

But is there any better ways ?

Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

can you please help me on this?

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 9 2017

Added on Jan 12 2017

11 comments

19,276 views