select nls_territory from v$parameter
there are other nls_* parameters you may be interested in...
Thanks & Regards,
Manash Pratim Baruah | Tech Mahindra Ltd.
Sharda Centre, Off Karve Road, Pune - 411004, India.
www.techmahindra.com
-----Original Message-----
From: Luis Cardenas
[mailto:oracledba-ezmlmshield-x35154818.[Email address protected]
Sent: Tuesday, October 09, 2007 6:29 PM
To: LazyDBA Discussion
Subject: Oracle 9i Database Timezone question
Experts,
How can I find, from querying the database what timezone my db is at?
Thanks,
Luis
-----------------------------------------
This e-mail is sent on behalf of Trader Media Group Limited,
registered office: Unit 6, Thatcham Business Village, Colthrop
Lane, Thatcham, Berkshire RG19 4LW (Registered in England No.
4768840). This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error please notify the sender. This email message has been
swept for the presence of computer viruses. www.ciphertrust.com
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page