Mega Code Archive

 

Categories / MySQL / Date Time

 

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>