[RESOLVED] Auto populating date field

keram617

Hello
I am sure this question has come up in some form or another, but I have not been able to find an answer for it.

My question is this
I am trying to have a field in MySQL db to be automatically populated by current system date (server or the computer), I have looked at the DB side of it but no matter what I do it still throws zeros on everything.
If I want to code it into a INSERD recordset on my PHP for, how could I go about it?

Any suggestions will be very welcome.

Thank you

P.S. and yes I am reading the reference documentation on MySQL site also.

bradgrafelman

Use a TIMESTAMP column with the 'DEFAULT CURRENT_TIMESTAMP' option and then simply omit the column altogether from your INSERT queries (just as you would do for an AUTO_INCREMENT column).

bicky

Alternatively use the date funtion...

$today = date("d/m/y");

bradgrafelman

bicky;10958040 wrote:
Alternatively use the date funtion...

$today = date("d/m/y");

You could do that (the format string should be "Y-m-d", by the way :p), or you could use MySQL's CURDATE() function as well.

I didn't mention either of those methods, though, since the OP seems interested in a more automatic method (which is what TIMESTAMP columns are for).

keram617

Thank you
that worked
I will simply remove the field so it is not visible or make it not editable, because I do want that field to be emailed out also, once the form is completed and submited.

bradgrafelman;10958031 wrote:
Use a TIMESTAMP column with the 'DEFAULT CURRENT_TIMESTAMP' option and then simply omit the column altogether from your INSERT queries (just as you would do for an AUTO_INCREMENT column).

bradgrafelman

Don't forget to mark this thread resolved (if it is) using the link on the Thread Tools menu above.