Predmet:Re: ORDER BY [uvjet] vrijeme ASC, [uvijet] vrijeme DESC

---

evo ga:

SELECT voce, HOUR(STR_TO_DATE(mojaTabla.vrijeme, '%H:%i')) as sati
FROM mojaTabla
ORDER BY
(CASE WHEN sati < 3 then sati end) ASC,
(CASE WHEN sati > 3 then sati END) DESC

nije bas neko rijesenje ali za sada prolazi

---