Re: Insert Date (newbie)

[Kevin Miller]

Yes you need to reference the field in your query.

So lets says I have a datetime column called "mytime" in the table "mytable" and I want to insert a new record to the current time:

INSERT INTO mytable SET mytime=now();

Another method would be to use the TIMESTAMP column that is set to update to the current time automatically whenever its particular record is edited.

|<>|