SELECT NOW() AS d1;
SELECT CURRENT_TIMESTAMP() AS d2;

SELECT YEAR(NOW());
SELECT DATE(NOW());
SELECT CURDATE();
SELECT CURDATE() + 0;
SELECT CURTIME(6);

SELECT DATEDIFF(NOW(), '2023-09-01');

SELECT NOW(), ADDDATE(NOW(), 2);
SELECT NOW(), ADDDATE(NOW(), INTERVAL 2 DAY);
SELECT NOW(), ADDDATE(NOW(), INTERVAL 2 HOUR);
SELECT NOW(), ADDDATE(NOW(), INTERVAL '2:15' HOUR_MINUTE);

SELECT NOW(), DATE_FORMAT(NOW(), '%d %M %Y');
SELECT @@lc_time_names;
SET lc_time_names = 'ru_RU';
SELECT @@lc_time_names;
SELECT NOW(), DATE_FORMAT(NOW(), '%d %M %Y');
SELECT NOW(), DATE_FORMAT(NOW(), '%d.%m.%Y %H:%i');

SELECT datetime_f, DATE_FORMAT(datetime_f, '%d.%m.%Y %H:%i') AS format_date FROM users;