>Hi all,
>
>i have a datetime field in a mysql database and it's defined with a default
>of '0000-00-00 00:00:00:'
>
>now, when i add a record to the database, i want to fill that field with >the date
>and current time.
>
>can anyone point me ?
Via PHP:
$dateTime = date('Y-m-d H:i:s');
mysql_query("INSERT INTO table SET dateTime = '$dateTime'");
Via MySQL:
mysql_query("INSERT INTO table SET dateTime = NOW()");
Take a look here for other useful MySQL date and time functions:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Hope it helps. Regards,
Torsten Roehr
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
