Weis nicht genau was du vorhast?
Code:
SELECT DATE_FORMAT( DATE_ADD(NOW(), INTERVAL 5 YEAR), "%Y") AS Springe_zu_Jahr;
SELECT PERIOD_DIFF(DATE_FORMAT(NOW(),"%Y"),DATE_FORMAT(DATE_SUB(NOW(),INTERVAL 3 YEAR),"%Y") ) AS VERGANGENHEITS_VISIONEN;
Oder mit einem Referenz wert tricksen.
Code:
SELECT DATE_FORMAT(DATE_ADD(NOW(), INTERVAL id YEAR),"%Y"), id FROM tippspiel_teams;
+-----------------------------------------------------+----+
| DATE_FORMAT(DATE_ADD(NOW(), INTERVAL id YEAR),"%Y") | id |
+-----------------------------------------------------+----+
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 4 |
| 2014 | 6 |
+-----------------------------------------------------+----+
4 rows in set (0.00 sec)
Lesezeichen