Hi everyone,

I have a client-server application and would like to add a new feature
that requires the following procedure:

When a client click a button, the server (MySql) generates a new
record in the database and updates the field ACTUAL_DATE with the
server's date and time (NOT the client's). Do I have to use
triggers/stored procedures?

Note that there is a possibility that the client receive the server's
Date and Time before creation of the new record, and then he (client)
send an SQL creating and updating the field. In this case is it
possible to write an SQL expression requiring the server date and time?

Thanks in advance!