Field to populate with current system Date and Time

[jestrada101]

How can I populate a field with current system date and time? Is there an option to automatically populate this when a record is inserted?

 

[KarveR]

insert into table field1,field2,datefield values ('data','data2,NOW())....

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[ggggus]

you can also create a column "timestamp not null" and it will always update with a unix timestamp when you update that record.

***************************************
J. Jacobs

http://www.piercedmedia.com

 

[r937]

ggggus is right, timestamp will automatically update for every insert or update, except it doesn't use unix numbers

r937.com | rudy.ca