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?...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
|
#1
| |||
| |||
| How would you determine the time zone under which a database was operating in ORACLE?
__________________ Thanks & Regards Sabari... |
|
#2
| |||
| |||
| HI, SQL Query for time zone for database server opertating system Code: select DBTIMEZONE from dual; |
|
#3
| |||
| |||
| 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. |
![]() |
| Thread Tools | |
| Display Modes | |
| |
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 |
Our Partners |