It should be
NOW()
.
OP: NOW() its only working for date..thatis not considering month or year
For Month & Year you have to check like below.
SELECT tid FROM train WHERE MONTH(dfdate) > MONTH(NOW())
SELECT tid FROM train WHERE YEAR(dfdate) > YEAR(NOW())
For more info check
this[
^].