what type of data use in mysql to save data time

Question

I create an html form and I used HTML5 datatype field to insert data.what type of mysql attribute I could use to save the datatime in a db?

<input type="datetime" name="dt" id="dt" value="" placeholder="Date"/>

You'll need to convert it to a format that the `DATETIME` column type understands. — ceejayoz, Feb 09 '12 at 21:35
http://stackoverflow.com/search?q=%5Bmysql%5D+data+type+for+time Many many related questions.... — Michael Berkowski, Feb 09 '12 at 21:36
possible duplicate of [Mysql date field, why so many options?](http://stackoverflow.com/questions/6378444/mysql-date-field-why-so-many-options) — Michael Berkowski, Feb 09 '12 at 21:37
Also see http://stackoverflow.com/questions/4562888/which-is-the-better-way-of-storing-date-and-time-in-mysql — Michael Berkowski, Feb 09 '12 at 21:39

score 0 · Answer 1 · answered Feb 09 '12 at 21:37

0

You'll probably want to use the DATETIME data type.
Have a loot at the Manual.

answered Feb 09 '12 at 21:37

Madara's Ghost

1 Answers1