| Changing Time Zone in Oracle 8.1.7 [message #165381] |
Wed, 29 March 2006 13:31  |
somnathganguly123
Messages: 1
Registered: May 2005
|
Junior Member |
|
|
I want to change time zone of a database.I do the following steps but it won't wotk.
SQL>SELECT DBTIMEZONE FROM DUAL;
DBTIMEZ
-------
+00:00
SQL>select to_char(sysdate,'dd-mon-yy hh:mi:ss') from dual;
TO_CHAR(SYSDATE,'D
------------------
29-mar-06 02:13:56
SQL>alter database set time_zone='-03:00';
Database altered.
SQL>shutdown immediate
SQL>startup
SQL>SELECT DBTIMEZONE FROM DUAL;
DBTIMEZ
-------
-03:00
SQL> select to_char(sysdate,'dd-mon-yy hh:mi:ss') from dual;
TO_CHAR(SYSDATE,'D
------------------
29-mar-06 02:15:45
Can any one suggest how i can change time zone?
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
