SELECT
rental_date,
YEAR(rental_date) AS year,
MONTH(rental_date) AS month,
DAY(rental_date) AS day,
DATE_FORMAT(rental_date, '%d.%m.%Y') AS ru_format
FROM rental
| rental_date | year | month | day | ru_format |
| 2005-05-24 22:53:30 | 2005 | 5 | 24 | 24.05.2005 |
| 2005-05-24 22:54:33 | 2005 | 5 | 24 | 24.05.2005 |
| 2005-05-24 23:03:39 | 2005 | 5 | 24 | 24.05.2005 |
| 2005-05-24 23:04:41 | 2005 | 5 | 24 | 24.05.2005 |
| 2005-05-24 23:05:21 | 2005 | 5 | 24 | 24.05.2005 |
| 2005-05-24 23:08:07 | 2005 | 5 | 24 | 24.05.2005 |
| 2005-05-24 23:11:53 | 2005 | 5 | 24 | 24.05.2005 |
| 2005-05-24 23:31:46 | 2005 | 5 | 24 | 24.05.2005 |
| 2005-05-25 00:00:40 | 2005 | 5 | 25 | 25.05.2005 |
| ... |