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!

YYYY-MM-DD date format in Oracle

TinaNov 2 2016 — edited Nov 4 2016

Hi Gurus,

    Unless we alter the NLS date parameter , oracle stores date in mm/dd/yyyy format.

    Is there a way we can store date in yyyy-mm-dd format in a particular table as a date?

    Using to_char(sysdate,'yyyy-mm-dd') serves the purpose but this will be a string instead of Date.

   Is there a way we can convert date to yyyy-mm-dd format which will be a date and not a string?

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 2 2016
Added on Nov 2 2016
16 comments
26,173 views