latdate()

DROP FUNCTION latdate; DELIMITER // CREATE FUNCTION latdate() RETURNS CHAR(50) DETERMINISTIC BEGIN SELECT curdate() INTO @t; CASE month(@t) WHEN 1 THEN SELECT 'janvāris' INTO @m; WHEN 2 THEN SELECT 'februāris' INTO @m; WHEN 3 THEN SELECT 'marts' INTO @m; WHEN 4 THEN SELECT 'aprīlis' INTO @m; WHEN 5 THEN SELECT 'maijs' INTO @m; WHEN 6 THEN SELECT 'jūnijs' INTO @m; WHEN 7 THEN SELECT 'jūlijs' INTO @m; WHEN 8 THEN SELECT 'augusts' INTO @m; WHEN 9 THEN SELECT 'septembris' INTO @m; WHEN 10 THEN SELECT 'oktobris' INTO @m; WHEN 11 THEN SELECT 'novembris' INTO @m; WHEN 12 THEN SELECT 'decembris' INTO @m; END CASE; /*@latd ENUM('pirmdiena', 'otrdiena', 'trešdiena', 'ceturdiena', 'piektdiena', 'sestdiena', 'svetdiena'); */ CASE weekday(@t) WHEN 0 THEN SELECT 'Pirmdiena' INTO @d; WHEN 1 THEN SELECT 'Otrdiena' INTO @d; WHEN 2 THEN SELECT 'Trešdiena' INTO @d; WHEN 3 THEN SELECT 'Ceturdiena' INTO @d; WHEN 4 THEN SELECT 'Piektdiena' INTO @d; WHEN 5 THEN SELECT 'Sestdiena' INTO @d; WHEN 6 THEN SELECT 'Svetdiena' INTO @d; END CASE; RETURN CONCAT('Šodien ir: ',year(@t),'. gada ',dayofmonth(@t),'. ',@m,', ',@d,'.'); /*SELECT year(@t) INTO @year;*/ END // DELIMITER ; SELECT latdate();