Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Change date in Sco Unix 4.2

Posted on 2003-12-07
6
Medium Priority
?
4,889 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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 1500 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Attention: This article will no longer be maintained. If you have any questions, please feel free to mail me. jgh@FreeBSD.org Please see http://www.freebsd.org/doc/en_US.ISO8859-1/articles/freebsd-update-server/ for the updated article. It is avail…
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…
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.
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.
Suggested Courses

688 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