Tag: Timestamp

MySQL Date Format: What Datatype Should You Use? We Compare Datetime, Timestamp and INT.

.tips { margin-top: 0px; text-align: left; max-width: 90%; padding: 20px 20px 30px 30px; background-color: #f2f2f2; text-indent: 0px; border: 0px solid #360063; border-radius: 8px; -webkit-border-radius: 8px; -moz-border-radius: 8px; -khtml-border-radius: 8px; } .blog_article h5 { font: normal normal bold 1.05em 'Lato'; } Whenever you need to save datetime data, a question arises about what MySQL type to use. Do you go with a native MySQL DATE type or use an INT field to store date and time info as a plain number?