Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .