Looks like fixed_date is set in your database. Unset it (init.ora and or
alter system) and
bounce your db. Under normal circumstances your db time should be the
same as OS
time unless otherwise TZ is set at OS level and the db started.

HTH
GovindanK
Oracle Certified Professional(8,8i)
Brainbench Certified Master DBA

<-----Original Message----->
From: [Email Address Removed] 10/31/2003 9:52:23 AM
To: [Email Address Removed] RE: Changing DB time

I need my database time to reflect my Unix OS time. Right now my OS time
is :
$date
Fri Oct 31 08:38:01 CST 2003
On my database the time is :
SQL> select to_char(dbdate,'mm-dd:hh-mm') from dual;

TO_CHAR(DBD
-----------
10-31:08-10
*** Also the time never changes from 8:10 on the database. I need it to
always
match what is on UNIX



_____________________________
Brad Ralston

Database Administrator
George's Inc.
402 W. Robinson
Springdale, AR 72764
Phone :479-927-7124
Email : [Email Address Removed] Your 10MB account for FREE at http://mail.arabia.com !
Access MILLIONS of JOBS NOW!
<http://ads.arabia.com/?SHT=text_email_english>
Oracle LazyDBA home page