【MySQL】内置函数
欢迎拜访：雾里看山-ZEEKLOG博客
本篇主题：【MySQL】内置函数
发布时间：2025.2.20
隶属专栏：MySQL
目录
日期函数
函数介绍
| 函数名称 | 描述 |
|---|---|
| current_date() | 当前日期 |
| current_time() | 当前时间 |
| current_timestamp() | 当前时间戳 |
| date(datetime) | 返回 datetime 参数的日期部分 |
| date_add(date, interval d_value_type) | 在 date 中添加日期或者时间 interval 后的数值单位可以是：year minute second day |
| date_sub(date, interval d_value_type) | 在 date 中减去日期或者时间 interval 后的数值单位可以是：year minute second day |
| datediff(date1,date2) | 两个日期的差，单位是天 |
| now() | 当前日期时间 |
函数使用
current_date() 获得年月日
mysql>selectcurrent_date();+----------------+|current_date()|+----------------+|2025-02-18|+----------------+1rowinset(0.02 sec)current_time() 获得时分秒
mysql>selectcurrent_time();+----------------+|current_time()|+----------------+|15:33:32|+----------------+1rowinset(0.00 sec)current_timestamp() 获得时间戳
mysql>selectcurrent_timestamp();+---------------------+|current_timestamp()|+---------------------+|2025-02-1815:33:37|+---------------------+1rowinset(0.00 sec)now() 获取日期时间
mysql>selectnow();+---------------------+|now()|+---------------------+|2025-02-1815:36:23|+---------------------+1rowinset(0.00 sec)date 截取日期
参数是具体时间
mysql>selectdate('1949-10-01 00:00:00');+-----------------------------+|date('1949-10-01 00:00:00')|+-----------------------------+|1949-10-01|+-----------------------------+1rowinset(0.00 sec)参数是时间函数
mysql>selectdate(now());+-------------+|date(now())|+-------------+|2025-02-18|+-------------+1rowinset(0.00 sec)date_add 日期加
具体日期加时间
mysql>select date_add('2050-01-01',interval10day);+-----------------------------------------+| date_add('2050-01-01',interval10day)|+-----------------------------------------+|2050-01-11|+-----------------------------------------+1rowinset(0.00 sec) mysql>select date_add('2050-01-01',interval10month);+-------------------------------------------+| date_add('2050-01-01',interval10month)|+-------------------------------------------+|2050-11-01|+-------------------------------------------+1rowinset(0.00 sec)函数日期加时间
mysql>selectnow();+---------------------+|now()|+---------------------+|2025-02-1815:47:57|+---------------------+1rowinset(0.00 sec) mysql>select date_add(now(),interval10month);+------------------------------------+| date_add(now(),interval10month)|+------------------------------------+|2025-12-1815:47:59|+------------------------------------+1rowinset(0.00 sec)date_sub 日期减
具体日期减时间
mysql>select date_sub('2050-01-01',interval10day);+-----------------------------------------+| date_sub('2050-01-01',interval10day)|+-----------------------------------------+|2049-12-22|+-----------------------------------------+1rowinset(0.00 sec) mysql>select date_sub('2050-01-01',interval10month);+-------------------------------------------+| date_sub('2050-01-01',interval10month)|+-------------------------------------------+|2049-03-01|+-------------------------------------------+1rowinset(0.00 sec)函数日期加时间
mysql>selectnow();+---------------------+|now()|+---------------------+|2025-02-1815:49:50|+---------------------+1rowinset(0.00 sec) mysql>select date_sub(now(),interval10month);+------------------------------------+| date_sub(now(),interval10month)|+------------------------------------+|2024-04-1815:50:00|+------------------------------------+1rowinset(0.00 sec)datediff 日期差
mysql>select datediff('2020-10-23','2013-04-13');+--------------------------------------+| datediff('2020-10-23','2013-04-13')|+--------------------------------------+|2750
