When a record is created in a MySQL database, is the date the record is created automatically stored, or do I have to make a field to store this info?

You have to create a field to store this information.

Simply create a field in your table:

TIMESTAMP

regards

Yeah, or you can just do DATE as the variable type and manually enter it, by manually you could just use php's date functions. (I did this on a site where I could only allow one entry into the DB per day and saved on php code over TIMESTAMP).

Be aware TIMESTAMP will update itself to the current time whenever the record is updated as well as when it is created.

Timestamp is definitely not the way to go. Use the datetime field if it exists.

I generally use int(10) and manage the unix timestamp via code.

You could use the PHP time() function to create the timestamp in the first place.

You can then use functions such as date, mktime, strtotime, etc. to manage the timestamp and calc dates.

Originally posted by solidphp
I generally use int(10) and manage the unix timestamp via code.

You could use the PHP time() function to create the timestamp in the first place.

You can then use functions such as date, mktime, strtotime, etc. to manage the timestamp and calc dates.

Actually, use the mysql function;


UNIX_TIMESTAMP()


There are several ways you can impliment it. Review the following url for more information;


http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

Originally posted by Content-Type.com
Actually, use the mysql function;


UNIX_TIMESTAMP()


There are several ways you can impliment it. Review the following url for more information;


http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

thanks thats really usefull i'll check it out at home later.