Basic MySQL question

[DigitalCreation]

I'm pretty new to mysql, .. ok, .. very new, when inserting a record I'm wanting the mysql to automatically add the time it was updated. Using Now() in access would do this,. but when I add the now() default to the default ( using mysql front) it throws up the 0000-00-00 00:00:00 and when I add and retrive the date, . obviously I don't get anything.. should I be using something other than Now()?

D.C.

[randem]

If you use a "Timestamp" field, the time will be automatically added or updated whenever you insert or update the record.

[Technosailor]

If you use UNIX_TIMESTAMP() instead you get a number similar to this 1036548245. It doesn't look great...actually means number of seconds since midnight, January 1st, 1970. But it's raw data that you can later use for whatever format or use you might find for it...just my recommendation.

Aaron