MySQL - dates

• MySQL - DATE, TIME, DATETIME, and TIMESTAMP differences
• MySQL - DATEDIFF() function example
• MySQL - DATE_FORMAT() function example
• MySQL - HOUR() function example
• MySQL - MINUTE() function example
• MySQL - NOW() function example
• MySQL - SECOND() function example
• MySQL - TIMEDIFF() function example
• MySQL - TIMESTEMP() function example
• MySQL - WEEKDAY() and DAYOFWEEK() differences
• MySQL - combine DATE and TIME column into TIMESTAMP
• MySQL - combine DATE and TIME into TIMESTAMP
• MySQL - compare datetime values
• MySQL - convert date to month name
• MySQL - convert date to weekday name
• MySQL - convert date to weekday number
• MySQL - count rows per day
• MySQL - count rows per hour
• MySQL - count rows per month
• MySQL - count rows per year
• MySQL - date to string (dd/mm/yyyy)
• MySQL - difference between two dates
• MySQL - difference between two datetimes
• MySQL - difference between two time values
• MySQL - extract HOUR from DATETIME / TIMESTAMP / TIME
• MySQL - extract MINUTE from DATETIME / TIMESTAMP / TIME
• MySQL - extract SECOND from DATETIME / TIMESTAMP / TIME
• MySQL - get current date and time
• MySQL - group datetime by time hour
• MySQL - group rows by year
• MySQL - select between two dates
• MySQL - set current DATETIME as default
• MySQL - strip time from datetime column
• MySql - group rows by days
• MySql - group rows by months
• MySql - how to convert unix timestamp to datetime?
• MySql - select rows with dates between
• MySql - subtract days from current date