Re: datetime update
| From: | roehr at zilleon dot com | Date: | Thu, 10 Jun 2004 09:09:53 +0000 |
| Subject: | Re: datetime update | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-34698@lists.php.net to get a copy of this message | ||
>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