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!

Sort data from date format DD/MMM/RRRR

User579817-OCFeb 17 2016 — edited Feb 18 2016

Hello

I have to sort our data between two dates ex 01/01/2016 to 31/01/2016 to get the list of transactions.

Shall I convert it into JAN-16 format so that I can sort it by where period_name like 'JAN-16'?

if so how to I convert a date format from 01/01/2016 to JAN-16??

thank you

This post has been answered by Frank Kulash on Feb 17 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 17 2016

Added on Feb 17 2016

12 comments

2,936 views