MySQL:- Date Types & Sizes

Background Playing around more with MySQL and wanted to see why a certain implementation specification was chosen over another. I really struggled to make sense of things. Date Types & Sizes There are a couple of types that one can use for date & time in MySQL. Inclusive:- time date datetime timestamp Code Output