Skip to Main Content

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!

format of the date column when ordering by it

goodluck247Jun 20 2017 — edited Jun 20 2017

Hello all,

Quick question - does it matter which date format we use (e.g., 'DD-MON-YYYY', 'MM-DD-YYYY', 'YY-MON-DD') when we order by this column?

Is there a preferred format which would ensure the query runs faster?

Thank you.

This post has been answered by Frank Kulash on Jun 20 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2017
Added on Jun 20 2017
6 comments
12,835 views