Mysql time/timestamp types

[edwardp]

Is it possible for mySQL to autofill these fields if an insert script is succesful?

How could this be done?

Is it better to generate a time using the mktime()/date function in php first?

[Installer]

You can have a TIMESTAMP field autofill with the current MySQL timestamp if you define the column like this:

my_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP

Then leave the column out of the column list when you do the INSERT.

[edwardp]

thanks for your help