Convert a timestamp to date in sql

Most sql servers, including MySQL, are able to do some conversions and calculations for you. This is relevant if you want to perform a query directly on the sql server or if you want the conversion or calculation to be done in the sql server before it is ...