3 ms·
mysql> SELECT TIMESTAMPDIFF(YEAR,CURDATE(), "2050-01-01"); +---------------------------------------------+ | TIMESTAMPDIFF(YEAR,CURDATE(), "2050-01-01") |
by raverbashing 10y ago
mysql> SELECT TIMESTAMPDIFF(YEAR,CURDATE(), "2050-01-01");
+---------------------------------------------+
| TIMESTAMPDIFF(YEAR,CURDATE(), "2050-01-01") |
+---------------------------------------------+
| 33 |
+---------------------------------------------+
Seems to work fine
- jdub 10y agoThat's just the database, and one that we happen to know works.
- raverbashing 10y agoThe original comment referred to exactly this database, so it is relevant