Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 4. Storing and Processing Dates ... > Setting the Default Date Format

Setting the Default Date Format

The default date format is specified in the NLS_DATE_FORMAT database parameter. Your DBA can change the setting of NLS_DATE_FORMAT by setting this parameter’s value in the database’s init.ora or spf ile.ora file, which is read when the database is started. Your DBA can also set NLS_DATE_FORMAT using an ALTER SYSTEM command.

You can also set the NLS_DATE_FORMAT parameter for your own session using SQL*Plus. You do this using ALTER SESSION.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint