[cvele]

ako i nisu u pravom formatu mozes recimo:

select year(str_to_date(datum, '%Y-%m-%d')) as godina,
month(str_to_date(datum, '%Y-%m-%d')) as mesec,
dayofmonth(str_to_date(datum, '%Y-%m-%d')) as dan 
from tabela