Skip to content

Instantly share code, notes, and snippets.

DELIMITER //
CREATE PROCEDURE INFLUENCE_OF_TIME_OF_DAY()
BEGIN
SELECT
CASE
WHEN HOUR(time) BETWEEN 6 AND 11 THEN "Утро"
WHEN HOUR(time) BETWEEN 12 AND 17 THEN "День"
WHEN HOUR(time) BETWEEN 18 AND 23 THEN "Вечер"
ELSE "Ночь"
END AS time_of_day,