MySQL MAKEDATE()

MySQL 날짜함수, 시간함수

 

MAKEDATE()

   - 주어진 값으로 날짜를 생성?

 

MAKEDATE(year, dayofyear)

의 형태

 

Return a date, given year and day-of-year values, dayofyear must be greater tnan 0 or result is NULL.

 

 

mysql> SELECT MAKEDATE(2011, 31), MAKEDATE(2011, 32);
+--------------------+--------------------+
| MAKEDATE(2011, 31) | MAKEDATE(2011, 32) |
+--------------------+--------------------+
| 2011-01-31         | 2011-02-01         |
+--------------------+--------------------+
1 row in set (0.00 sec)

 

 

mysql> SELECT MAKEDATE(2011, 0);
+-------------------+
| MAKEDATE(2011, 0) |
+-------------------+
| NULL              |
+-------------------+
1 row in set (0.00 sec)