php insert into datetime

[ddellostritto]

Hi all -

I've created a form to create events, but I can't figure out how to insert the date of the event properly into mysql (I'm not interested in inserting the time the register will be created, as that would be timestamp).

I've got the column set as datetime but I don't know how to insert into this. When I do insert a new row this column appears as 0000-00-00 00:00:00. I could always store this as a varchar but I figured this would be more 'appropriate'(?).

Thanks!

[pritaeas]

Insert a date in this format: 'yyyy-mm-dd'

[ddellostritto]

Thanks Priaeas!