IT Community - Software Programming, Web Development and Technical Support

How would you determine the time zone under which a database was operating?

This is a discussion on How would you determine the time zone under which a database was operating? within the Database Support forums, part of the Web Development category; How would you determine the time zone under which a database was operating in ORACLE?...


Go Back   IT Community - Software Programming, Web Development and Technical Support > Web Development > Database Support

Register FAQ Members List Calendar Mark Forums Read
  #1  
Old 07-19-2007, 01:53 AM
Sabari Sabari is offline
D-Web Genius
 
Join Date: Jul 2007
Posts: 945
Sabari is on a distinguished road
Red face How would you determine the time zone under which a database was operating?

How would you determine the time zone under which a database was operating in ORACLE?
__________________
Thanks & Regards
Sabari...
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 07-19-2007, 02:12 AM
Gopisoft Gopisoft is offline
D-Web Sr.Programmer
 
Join Date: Feb 2007
Posts: 119
Gopisoft is on a distinguished road
Default Re: How would you determine the time zone under which a database was operating?

HI,

SQL Query for time zone for database server opertating system
Code:
select DBTIMEZONE from dual;
-R.Gopi
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3  
Old 07-19-2007, 04:11 AM
Murali Murali is offline
D-Web Master
 
Join Date: Feb 2007
Location: India-Chennai.
Posts: 385
Murali is on a distinguished road
Send a message via AIM to Murali
Default Re: How would you determine the time zone under which a database was operating?

The Other Ways to get it,

1. SELECT PROPERTY_VALUE FROM DATABASE_PROPERTIES WHERE PROPERTY_NAME = 'DBTIMEZONE' ;
2. SELECT * FROM sys.props$ WHERE NAME = 'DBTIMEZONE';
__________________
-Murali..

Last edited by Murali : 07-19-2007 at 04:14 AM.
Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
How does rolling back domain time affect database applications arjkhanna Operating Systems 2 06-25-2009 08:12 PM
How can I set the time zone for MySQL to UK time? itbarota PHP Programming 1 09-12-2007 12:13 AM
How Can I determine the phone number from my MIDlet? mobilegeek Mobile Software Development 1 07-23-2007 09:43 PM
Determine execution time in PHP bluesky PHP Programming 1 07-21-2007 12:40 AM
Brand New Dmoz Resource Zone Launched sfod223 Search Engine Optimization 0 02-19-2007 09:01 AM


All times are GMT -7. The time now is 06:16 PM.


Copyright ©2004 - 2007, DiscussWeb. All Rights Reserved.
Our Partners
One Way Moving Companies | Stamford Dentist | Euro Millions Lottery | Home Loans| Furniture

SEO by vBSEO 3.0.0