MySQL: DATE vs DATETIME vs TIMESTAMP

Many times while working with MySQL date-time column, one confusion or question come to our mind and that's,       Which data type should I use DATETIME or TIMESTAMP, as both stores the same data? First, Let's take a look over all three date-related data types available in MySQL - DATE : Value: Having …