Inserting a datetime value from php into MySQL

Question

Hello,

I have a column with datetime datatype called 'updated_at' in a mysql table,where i want the current date and time.Im trying to insert a record into the mysql table from php,as follows:

mysql_query("INSERT INTO my_table (service_name,service_status,service_comment,user_name,updated_at) VALUES($service_name,$service_status,$service_comment,$user_name,$updated_at) ")

$updated_at is defined as follows:

$updated_at = date("D, d M Y H:i:s O");

But the insert is not taking place. Any way to fix this problem ?

Please help Thank You

Answer 1

Use a date format that MySQL understands:

$updated_at = date('Y-m-d H:i:s');

Answer 2

INSERT INTO my_table (service_name,service_status,service_comment,user_name,updated_at) VALUES($service_name,$service_status,$service_comment,$user_name,NOW())

For mode details, see reference for NOW() function.

Answer 3

date('Y-m-d H:i:s') OR use NOW() OR set default value to collumn CURRENT_TIMESTAMP