Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. February 29 of leap years and March 1 of non-leap years appear to be the same day
mysql>
mysql>
mysql> SELECT DAYOFYEAR('1996-02-29'), DAYOFYEAR('1997-03-01');
+-------------------------+-------------------------+
| DAYOFYEAR('1996-02-29') | DAYOFYEAR('1997-03-01') |
+-------------------------+-------------------------+
|                      60 |                      60 |
+-------------------------+-------------------------+
1 row in set (0.00 sec)
mysql>