CODEWITHSUNDEEP
mysqlsql
S.M_Emamian
S.M_Emamian

Reputation: 17383

DAYOFYEAR function returns different day of years

First query returns 72 value and second query returns 71:

SELECT DAYOFYEAR('2020-03-12');


SELECT DAYOFYEAR('1990-03-12');

why this happened?

Upvotes: 0

Views: 49

Answers (1)

Chris Halcrow
Chris Halcrow

Reputation: 31960

2020 is a leap year. 1990 isn't. In 2020 Feb had 29 days. In 1990 there were only 28.

Upvotes: 2

Related Questions