get the current time

[Ni3ls]

Hi all,

Im trying to work with mysql and stuff and came across this post by izno

foo() 
{ 
    asyncQuery("SELECT NOW() AS `time`", ::showTime); 
}

showTime(rows, args) 
{ 
   if(isDefined(rows) && isDefined(rows[0]) && isDefined(rows[0]["time"])) 
      iprintlnbold("It is " + rows[0]["time"]); 
}

It does work, however the time is incorrect.
I live in the Netherlands (GMT +1), tested it at 10:58, but time shows 10:15.
What time does it show?

[Whiskas]

Isn't it time of your vps? Check date command in ssh client.

[Ni3ls]

Isn't it time of your vps? Check date command in ssh client.

Yes you are right. How can I fix this?

[voron00]

Yes you are right. How can I fix this?

		sudo apt-get install ntpdate
sudo ntpdate -s time.nist.gov 
	

Or just

		date --set="23 June 1988 10:00:00"
date --set="10:00:00" 
	

[IzNoGoD]

And if you're running on an openvz/docker/lxc vps: shout at your host to fix it.