OraFAQ Forum: Server Administration » Default Date format set up values selection Oracle 9i/10g

Home » RDBMS Server » Server Administration » Default Date format set up values selection Oracle 9i/10g

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Default Date format set up values selection Oracle 9i/10g [message #146137]

Tue, 08 November 2005 20:21

mymot
Messages: 225
Registered: July 2005

Senior Member

Hi,

How can i find out what date format is set on oracle server

i can query dual

select sysdate from dual;

i will get DD-MON-YY (default)
in v$parameter i have checked isdefault = TRUE then above format but if its false then how can find out below format is set or not

Querying dual will give me the actual value but i want to find out date format.

but if it set something

DD-MON-YYYY HH24:MI:SS
OR
DD-MON-YYYY HH12:MI:SS

Then how can i get above format in oracle server to figure it out which one is currently set.

DD-MON-YYYY HH24:MI:SS
OR
DD-MON-YYYY HH12:MI:SS
OR
DD-MON-YY
....
..

thanks

Report message to a moderator

Re: Default Date format set up values selection Oracle 9i/10g [message #146199 is a reply to message #146137]

Wed, 09 November 2005 04:25

Frank Naude
Messages: 4590
Registered: April 1998

Senior Member

Hi,

Try this:

SQL> SELECT *
  2    FROM nls_database_parameters
  3   WHERE parameter LIKE '%DATE%'
  4  /

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN

Best regards.

Frank

Report message to a moderator

Previous Topic:	How to set oracle case insensitive as default
Next Topic:	Adding a Column -- Performance issues

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 17:05:09 CST 2025