get system time from server

hi :wave:

I'm using vb6 and mysql(xampp) as my back end. My application will be install in each pc and the database will be on our server windows 2003.Is it possible that the time and date of my application will be based on the server?if yes how?

Thanks!

Yes, I think it would be something like Select @GETDATE AS THEDATE or you could the API NetRemoteTOD see http://vbnet.mvps.org/index.html?cod...tremotetod.htm



Good Luck

thanks!

I forgot to mention that i'll be using a timer and the time on the timer will be based on the server.I'm doing Attendance system:time in and out of employees.and they want to sync the time to the server.

This SQL query should work:

Code:

---

SELECT NOW()

---

If you already have the Conection to MySQL, then declare a Recordset and do something like..

Code:

---

  Set Rs = CN.Execute("SELECT NOW()")

---