Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4978
  • Last Modified:

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  
0
sukfliu
Asked:
sukfliu
1 Solution
 
yuzhCommented:
You can change the date in the PC BIOS (CMOS).

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.
0
 
edvinkvCommented:
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.
0
 
gheistCommented:
run date -y to see format it accepts
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
biraCommented:
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.
0
 
sppalserCommented:
if you have uod426d installed on your system then you should be y2k compliant and the date command will work correctly.  Use:

     date mmddhhmmyy

for example today is 12/09/03 and approx 3:52PM

     date 1209155203

Good Luck.

0
 
stan64Commented:
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.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now