Datetime and Timestamp in Mysql Database Table [duplicate]

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??

stackoverflow.com/questions/409286/datetime-vs-timestamp?rq=1 — naveen goyal
– naveen goyal, Commented Dec 20, 2013 at 8:18

Jalpesh Patel · Accepted Answer · 2013-12-20 08:21:33Z

1

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

answered Dec 20, 2013 at 8:21

Jalpesh Patel

3,17810 gold badges47 silver badges68 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Datetime and Timestamp in Mysql Database Table [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related