Stuart,
If the field is the only (or first) timestamp-type field in the table
columns, then the record will automatically have the current date/time
inserted when it is added. The only (or first) timestamp field will *also*
be updated every time you update the record.
View the timestamp field
MySQL provides a number of functions for handling dates and times:
http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
Cheers,
--V
Stuart Felenstein wrote:
I think this can be done, but tried a few times with
no success. I want a column in a table that sets a
timestamp.
Instead of pas
Hi
you try setting the column type to TIMESTAMP :)
http://dev.mysql.com/doc/mysql/en/DATETIME.html
Peter
> -Original Message-
> From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
> Sent: 19 August 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Fairly lame question
>
I think this can be done, but tried a few times with
no success. I want a column in a table that sets a
timestamp.
Instead of passing a value from the form though is
there a way mySql would automagically stamp the
records as they are inserted ?
and as a side note - would table type make any
dif