Posted by Colin McKinnon on 06/28/05 14:06

Mark D Smith wrote:

> Hi
>
> i am inserting various values in a mysql table via php. now the ID is auto
> increment but how do i get the datetime to update when i post the values
> to say the new ID (row) that my "INSERT INTO / VALUES sql statement has
> just preformed?
>
> i can format a string for the datetime and send that with the insert but
> just wondering if there is a shortcut.
>

erm...

INSERT INTO myTable (dateField) VALUES (now());

Go get a copy of the MySQL manual - there's a whole load of functions for
working with dates/times in MySQL

C.

[Back to original message]