Shulou(Shulou.com)05/31 Report--

This article will explain in detail how Oracle changes the default date format and session date format. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

Log in with sysdba

Then update the fields in the props$ table.

Update props$ set value = 'YYYY-MM-DD' where parameter =' NLS_DATE_FORMAT'

Then restart the database

Change the session date format

Alter session set nls_date_format = 'yyyy-mm-dd hh34:mi:ss'

This modification method is valid only for the current session. Note that it is for the current session, not the current sql*plus window. That is, if you change this and use the connect command to connect to the database or connect to another database with other users, the date format becomes invalid and returns to the default date format.

This is the end of this article on "how to change the default date format and session date format in Oracle". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.