Re: DATE problem

[Gregory Rafuse]

There's also a differnt way to set up a field type to automatically update with the current timestamp. Set up a timestamp type field this way:

CREATE TABLE blah (
...
`lastupdate` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
...
);

Each time a record is added to the table, this column is automagically updated with the current system timestamp in YYYY-MM-DD format, unless you have the default system format changed to something else.

Greg