在SQL中，提取日期中年份和月份的常用方法是使用日期和時(shí)間函數(shù)。以下是一些常見(jiàn)數(shù)據(jù)庫(kù)系統(tǒng)中提取年份和月份的示例：

MySQL

```sql

SELECT YEAR(date_column) AS year, MONTH(date_column) AS month

FROM your_table;

```

PostgreSQL

```sql

SELECT EXTRACT(YEAR FROM date_column) AS year, EXTRACT(MONTH FROM date_column) AS month

FROM your_table;

```

SQL Server

```sql

SELECT YEAR(date_column) AS year, MONTH(date_column) AS month

FROM your_table;

```

Oracle

```sql

SELECT TO_CHAR(date_column, 'YYYY') AS year, TO_CHAR(date_column, 'MM') AS month

FROM your_table;

```

SQLite

```sql

SELECT strftime('%Y', date_column) AS year, strftime('%m', date_column) AS month

FROM your_table;

```

請(qǐng)將 `date_column` 替換為你的日期列的名稱，`your_table` 替換為你的表名。這些函數(shù)會(huì)根據(jù)你的數(shù)據(jù)庫(kù)系統(tǒng)自動(dòng)提取出年份和月份。