## period_diff,extract
### 說明
| 函數 | 說明 |
| --- | --- |
| period_diff(p1,p2) | 返回周期p1和p2之間的月數,p1和p2格式為YYMM或YYYYMM |
| extract(unit FROM date) | 函數用于返回日期/時間的單獨部分 |
### 例子:查詢寶寶月齡
```sql
SELECT
id,
baby_name,
baby_birthday,
period_diff(
extract(YEAR_MONTH FROM curdate()),
extract(YEAR_MONTH FROM baby_birthday)
) AS baby_monthage
FROM
baby;
```
*****
### 附錄
#### extract函數中unit的值
| Unit 值 |
| --- |
| MICROSECOND |
| SECOND |
| MINUTE |
| HOUR |
| DAY |
| WEEK |
| MONTH |
| QUARTER |
| YEAR |
| SECOND\_MICROSECOND |
| MINUTE\_MICROSECOND |
| MINUTE\_SECOND |
| HOUR\_MICROSECOND |
| HOUR\_SECOND |
| HOUR\_MINUTE |
| DAY\_MICROSECOND |
| DAY\_SECOND |
| DAY\_MINUTE |
| DAY\_HOUR |
| YEAR\_MONTH |