MySQL DAYOFYEAR()

MySQL 날짜함수, 시간함수

 

DAYOFYEAR()

   - 년을 기준으로 해서 몇번째 일인지를 return.

 

DAYOFYEAR(date)

 

 

Retruns the day of the year for date, in the range 1 to 366.

 

mysql> SELECT DAYOFYEAR(NOW());
+------------------+
| DAYOFYEAR(NOW()) |
+------------------+
|               92 |
+------------------+
1 row in set (0.00 sec)

 

 

mysql> SELECT DAYOFYEAR('2020-01-01');
+-------------------------+
| DAYOFYEAR('2020-01-01') |
+-------------------------+
|                       1 |
+-------------------------+
1 row in set (0.00 sec)