Dates and Times in MySQL

oulevon · 09-06-2001, 11:00 PM

I've got a table in mysql that has a few columns. I want one of the columns to record a date and time for each row that is put into the table. I've been trying DATETIME and TIMESTAMP but with no success. I've been referring to the mysql documentation. Any ideas?

sykkn · 09-12-2001, 06:15 PM

Why not just have your script/program send the timestamp with the rest of the information?

You can set TIMESTAMP/DATETIME feild 'time = $timevar' along with the rest of the feild value pairs and you effectively have the time the row was added.

I did this with a php script I wrote to show visitors to my site and when they visited.

PHP Code:



<? 
....... 
 
$sqlquery = "INSERT INTO $table 
             (ip,referrer,search,url,date) 
             VALUES('$ip','$referrer','$search','$url','$datetime')"; 
 
........ 
?>

glj · 09-13-2001, 03:27 AM

If you want timestamp to record the time the record was put in the table, or when the record is updated, just leave that field as NULL in the values(...) part of the statement.

glj