Insert datetime into mysql problem.

[jrmontg]

I am putting the date and time into a hidden field and inserting it into a table.

This the code for the hidden field:

<?php echo date("YmdH:i:s") ?>

When I look at the record the date goes in but the time does not.

The field type is datetime.

Why doesn't this work? THanks

[BooRadLey]

Try:

date("Y-m-d H:i:s")

Hope this helps,

Brad

[jrmontg]

Got it. Thanks