Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need my laptops timestamp to be the same as that of a database, is there a utility I can use for this?

So far, I'm having to run select systimestamp from dual; on my database, working out the difference in time against my clock, and adjusting it manually.

Its quite awkward, and goes out of sync often. I also need to be precise (within 5 seconds) and its a nuisance..

share|improve this question
Might this be better suited to SO? If so can a mod please migrate? thanks – user155695 Sep 29 '10 at 10:37
Is the DB server in the same LAN like your laptops? Do you have administrative access to the server where your database is running on? – Martin Sep 29 '10 at 10:43
On same network yes, but I don't have access to server where DB is located, just SQLPlus connection. Thinking if a batch script could do this for me.. – user155695 Sep 29 '10 at 11:06
up vote 4 down vote accepted

I think you have at least two options:

  1. Ask the database admin to install a NTP (Network Time Protocol) server on the machine. You should then be able to retrieve the time from the DB servers with your laptops (instead of synching with a time server over the internet).
  2. Ask the database admin if it is possible to synch the server with an internet-hosted time server. You then need to synch the notebooks' time with that same time server to get the laptops into synch with the database server.
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.