Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, santhoshreddy.

Asked: May 17, 2017 - 7:12 am UTC

Last updated: May 19, 2017 - 10:40 pm UTC

Version: 11g

Viewed 1000+ times

You Asked

Hi,

I would like to know the Database Character Set and its Default Date Format and language territory details.
so would you tell me which table stores those details.

and Chris said...

You can find details of the date formats available at:

http://docs.oracle.com/database/122/SQLRF/Format-Models.htm#SQLRF00210

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

santhoshreddy podduturi, May 19, 2017 - 3:40 am UTC

i wanna know my Data Base Date Format not Date formats available in Oracle DB. for Example nls_Session_Parameters table stores information about session date format and other details.
so which table stores the info about data base character set ,language, date format at the time of installation.
Connor McDonald
May 19, 2017 - 10:40 pm UTC

select * from database_properties
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.