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

  • Interview Candidate
  • 12
  • 8951

Showing Answers 1 - 12 of 12 Answers

Lingaraju Chowdegowda

  • Mar 10th, 2015
 

Set NLS_DATE_FORMAT for new date format

  Was this answer useful?  Yes

Vinayak

  • 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