Solved

Change date in Sco Unix 4.2

Posted on 2003-12-07
6
4,735 Views
Last Modified: 2013-12-05
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
Comment
Question by:sukfliu
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 38

Expert Comment

by:yuzh
ID: 9892129
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
 
LVL 1

Expert Comment

by:edvinkv
ID: 9902193
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
 
LVL 62

Expert Comment

by:gheist
ID: 9902576
run date -y to see format it accepts
0
Independent Software Vendors: 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!

 
LVL 6

Expert Comment

by:bira
ID: 9903484
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
 
LVL 7

Accepted Solution

by:
sppalser earned 500 total points
ID: 9907918
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
 
LVL 1

Expert Comment

by:stan64
ID: 9921024
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

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello fellow BSD lovers, I've created a patch process for patching openjdk6 for BSD (FreeBSD specifically), although I tried to keep all BSD versions in mind when creating my patch. Welcome to OpenJDK6 on BSD First let me start with a little …
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question