Query failed SELECT DATE_FORMAT(adddate(curdate(),0), '%Y.%m.%d') as datum1, chrono.* FROM `chrono` WHERE mod((year(adddate(curdate(),0))-convert(substring(datum,1,4),UNSIGNED INTEGER)),10)=0 and month(adddate(curdate(),0))=replace(substring(datum,6,2),'??','01') and day(adddate(curdate(),0))=replace(substring(datum,9,2),'??','01') order by datum