Re: Select ? from dual...bring back ORACLE database date format...

On Wed, 12 Aug 1998 19:33:57 +0100, Alastair Cameron <alastair.cameron_at_cableinet.co.uk> wrote:
>
>What's the command I use ("SELECT ? from dual") to bring back the date
>format (American, British, etc) for an Oracle database. Do I bring back
>SYSDATE and parse it, or is there a better way to check that the Database
>has been correctly configured for British use.

Try select * from v$nls_parameters;
select * from v$parameter where name like '%date%';

>
>Thanks.
>
>--
>Alastair Cameron
>alastair.cameron_at_cableinet.co.uk
>
>
>

jg

-- 
These opinions are my own and not necessarily those of Information Quest or 
Pebble In The Sky http://www.informationquest.com mailto:jgarry_at_nospameiq.com
http://ourworld.compuserve.com/homepages/joel_garry   Remove nospam to reply.  
mailto:joel_garry_at_compuserve.nospam.com  "See your DBA?"  I AM the @#%*& DBA!