MySQL: DateTime; How to? Questions and Answers

In day to day working, Many times I'm used to google for many MySQL date-time related functions/queries. below are some of them and many more will be added to these in future. Please comments, if anyone has a better way for any of the HOW questions? and If anyone has any additional question, ask in …