Date

[niko]

What is the best way to insert a date field into a mysql database through PHP,

ive tried DATE()

and <?php echo date("j/n/y h:i a");?>

however sometimes these dont work right.

[sad69]

Check this out:
http://www.tek-tips.com/gviewthread....434/qid/808535

Sadiq.

[SDP2006]

I think MySQL has a TIMESTAMP field type.

http://dev.mysql.com/doc/mysql/en/DATETIME.html

[sidney]

if you want the date time at the time of inserting try now()