Datetime and Timestamp in Mysql Database Table

Question

Which is the better choice to choose whether timestamp or datetime.. I'm currently working in mysql . for date and time field in database table which is the better one?? and the reason to choose it??

http://stackoverflow.com/questions/409286/datetime-vs-timestamp?rq=1 — naveen goyal, Dec 20 '13 at 08:18

score 1 · Answer 1 · answered Dec 20 '13 at 08:21

Timestamp is used when you need modified date or insert date which automatically inserted by the system at the time of insert or edit record.

And datetime is use for you have to insert it when you are insert or edit record.

Choice is you to you What you required.

Thanks

Datetime and Timestamp in Mysql Database Table

1 Answers1