How do you change oracle default system date like mon-dd-yyyy

Showing Answers 1 - 4 of 4 Answers

Lingaraju Chowdegowda

  • Mar 10th, 2015

Set NLS_DATE_FORMAT for new date format

  Was this answer useful?  Yes


  • Apr 24th, 2015

alter session set nls_date_format=mon-dd-yyyy hh24:mi:ss

  Was this answer useful?  Yes

Purvesh Khanna

  • May 5th, 2015

If you are using sql developer then go to Tools ->> Preference ->> Database ->> NLS -->> Date Format.
Send the format as you want.

  Was this answer useful?  Yes

Ram Devineni

  • Nov 3rd, 2015

Alter session set nls_date_format=mon-dd-yyyy hh:mi:ss

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions