Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

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>