sukfliu
asked on
Change date in Sco Unix 4.2
I got a system which is Oracle database system run under Sco Unix 4.2. for circumstance I might need to change my system date. like 08/11/2003 to 08/11/2002, how can I make sure both Sco Unix 4.2 and Oracle databse be changed also?
so I not reallly familiar on both OS and Oracle. please advise me.
thanks
sukfliu
so I not reallly familiar on both OS and Oracle. please advise me.
thanks
sukfliu
sqlplus scott/tiger;
select sysdate from dual;
on the unix box run..
date to check the system data.
date can also be used to set the system date.
Thx.
select sysdate from dual;
on the unix box run..
date to check the system data.
date can also be used to set the system date.
Thx.
run date -y to see format it accepts
See man date in order to find out the format to use, for that
differs from some kind of unix.
Once Oracle gets the date from OS, it will be right to the
database.
differs from some kind of unix.
Once Oracle gets the date from OS, it will be right to the
database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
on 3.2.4.2 you also have a utility called asktime which is the same format as the time/date check when you boot the system. setclk will read/write the real time clock to/from your system time.
or login as root
use "date" command to retset the date
man date
to learn more
if you use "date" change the system date, you need to reboot your system.