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'(?).


Recommended Answers

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

Jump to Post

All 2 Replies

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.