Date Time Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Date Time Functions
  4. Deal with two-digit-year value
mysql>
mysql> SELECT TO_DAYS('1997-10-07'), TO_DAYS('97-10-07');
+-----------------------+---------------------+
| TO_DAYS('1997-10-07') | TO_DAYS('97-10-07') |
+-----------------------+---------------------+
|                729669 |              729669 |
+-----------------------+---------------------+
1 row in set (0.00 sec)
mysql>