Add date/time to MySQL table?

Question

How can I add the current date and time (the date and time set on the server) to a MySQL table?

Answer 1

CREATE TABLE t (ts TIMESTAMP ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP);

Answer 2

Do you want to add it to the table or just to the result set? You can add NOW() to the field list of any query to do that.

If you just want to know what time the server thinks it is try:

SELECT NOW();

Edit: the original of this answer erroneously used "GETDATE()" 'cause I totally missed the MySQL tag. Matt Solnit called me on it, and rightly so.

Answer 3

Pretty sure there's a NOW() function... link

Answer 4

You could use PHP date, if that fits the scenario. Something like this:

$nowTime = date("Y-m-d H:i:s", time());

Answer 5

use timestamp. easiest way, current_timestamp