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
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
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