Time Zones

Hello. I have 5 servers all using time in milliseconds. I am connecting to SQL to check server statuses. The host server (The one checking how many players and last time the server updated) has it's time in milliseconds off by about one full day. The funny thing is that all the servers are in the same building according to my host. Now my question is how do I get the current time in milliseconds that are all based off the same time. Is there a way to get the UTC time from the windows network.

 

Forseth11
Hello,

I used this to get the current time from the server

Code:java

    public static String getTime() {
        Calendar cal = Calendar.getInstance();
        cal.getTime();
        SimpleDateFormat sdf = new SimpleDateFormat("HH");
        return ( sdf.format(cal.getTime()) );
    }

 

msnijder30 that will not work because all 5 of my server all run on a different machine, and each machine's system time is messed op. So they are all at the same location but one has its time 24 hours behind. The others are just off by a couple seconds.

 

I think System.currentTimeMillis() is independent of timezones.

 

willeb96 I also think that is the solution, since that method returns the following:

I have used the method to check time before.

 

nlthijs48 willeb96 Those wont work because all the systems times are off.

 

If I understand correctly, you want to base the times of all servers based off a single server? Why not just pull the time from one of the servers, and set the time of the others to match the time you just pulled?

 

try placing a ntp server on 1 of your machines, then using a code like this:
http://www.avajava.com/tutorials/le...-service-using-the-network-time-protocol.html
To calculate the time difference, and use that time difference in a wrapper method for System.currentTimeMillis() (so it corrects the time)
EDIT, the following url may be a simpler ntp client: http://support.ntp.org/bin/view/Support/JavaSntpClient

 

I think you can also get the current time for a specific timezone via java's calendar. So if all servers use the same timezone to calculate their time from, then those should be sync.

 

blablubbabc All the times are not in sync so getting the same time zone will make it so they are still just as far apart.

ferrybig what is an ntp? If I have to get to the servers I can't only my host can.

 

ntp stands for: Network time protocol, if you make your own implementation of system.currenttime, you can use a public ntp host to lookup what the differences are with the local time on the machines, and subtract that difference from the real system.timeMillies().
Most used time host: pool.ntp.org

 

Can't you just set the correct time on your servers?
If for some reason not, try using CURRENT_TIMESTAMP as the default value in your MySQL table.