mysql extract结果类型_MySQL EXTRACT() 函数举例说明

摘要:

下文讲述MySQL数据库中 EXTRACT() 函数的功能简介说明，如下所示:

EXTRACT() 函数功能说明

EXTRACT() 函数用于返回日期/时间中的指定部分,例：年、月、日、小时、分钟等。

EXTRACT语法说明

EXTRACT(unit FROM date)

date:输入一个日期类型。

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

MySQL EXTRACT函数应用举例

mysql > select post_date from maomao_posts limit 10;

+---------------------+

| post_date |

+---------------------+

| 2014-12-01 15:29:30 |

| 2014-12-01 15:32:13 |

| 2014-12-01 15:34:44 |

| 2014-12-01 15:35:36 |

| 2014-12-02 16:28:05 |

| 2014-12-04 15:11:16 |

| 2014-12-09 10:39:52 |

| 2014-12-09 10:45:27 |

| 2014-12-11 14:53:12 |

| 2014-12-18 08:50:15 |

+---------------------+

10 rows in set (0.00 sec)

mysql > select extract(month from post_date),post_date from maomao_posts limit 8;

+-------------------------------+---------------------+

| extract(month from post_date) | post_date |

+-------------------------------+---------------------+

| 12 | 2014-12-01 15:29:30 |

| 12 | 2014-12-01 15:32:13 |

| 12 | 2014-12-01 15:34:44 |

| 12 | 2014-12-01 15:35:36 |

| 12 | 2014-12-02 16:28:05 |

| 12 | 2014-12-04 15:11:16 |

| 12 | 2014-12-09 10:39:52 |

| 12 | 2014-12-09 10:45:27 |

+-------------------------------+---------------------+

8 rows in set (0.00 sec)