|
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.
Navigation:
[Reply to this message]
|