PHP/MySQL Database Command for Date/Time

SurgeProto

Is there a value in MySQL that you can insert through an SQL Insert command that will put the current date/time in the proper format into the database? I know that sysdate does it for oracle, I was wondering if there was a similar command for MySQL. If not, whats the proper way to go about creating the current date and time and inserting it? Thanks in advance for any help.

hand

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2002-11-14 18:23:15 |
+---------------------+
1 row in set (0.00 sec)

mysql>

insert into table values (now());

http://www.mysql.com/doc/en/Date_and_time_functions.html