以下的文章主要介绍的是MySQL Date函数的实际应用其中包括如何获取当前时间的具体操作，Unix时间的具体应用，时间前后、时间间隔与时间转换的实际内容描述，以下就是文章的主要内容。
MySQL Date函数1、获取当前时间
MySQL>selectcurrent_timestamp(); +---------------------+ |current_timestamp()| +---------------------+ |2010-01-1821:24:37| +---------------------+ 1rowinset(0.00sec) MySQL>selectcurrent_date(); +----------------+ |current_date()| +----------------+ |2010-01-18| +----------------+ 1rowinset(0.00sec) MySQL>selectcurrent_time(); +----------------+ |current_time()| +----------------+ |21:24:46| +----------------+ 1rowinset(0.00sec)
MySQL Date函数2、Unix时间
MySQL>selectunix_timestamp(); +------------------+ |unix_timestamp()| +------------------+ |1263821184| +------------------+ 1rowinset(0.00sec) MySQL>selectfrom_unixtime(1263821182); +---------------------------+ |from_unixtime(1263821182)| +---------------------------+ |2010-01-1821:26:22| +---------------------------+ 1rowinset(0.00sec)
MySQL Date函数 3、时间前后
MySQL>selectdate_add(current_timestamp,interval1day); +---------------------------------------------+ |date_add(current_timestamp,interval1day)| +---------------------------------------------+ |2010-01-1921:27:53| +---------------------------------------------+ 1rowinset(0.00sec) MySQL>selectdate_add(current_time,interval1day); +----------------------------------------+ |date_add(current_time,interval1day)| +----------------------------------------+ |NULL| +----------------------------------------+ 1rowinset,1warning(0.00sec) MySQL>selectdate_add(current_date,interval1day); +----------------------------------------+ |date_add(current_date,interval1day)| +----------------------------------------+ |2010-01-19| +----------------------------------------+ 1rowinset(0.00sec) MySQL>selectdate_sub(current_timestamp,interval1day); +---------------------------------------------+ |date_sub(current_timestamp,interval1day)| +---------------------------------------------+ |2010-01-1721:28:41| +---------------------------------------------+ 1rowinset(0.00sec) MySQL>selectdate_sub(current_date,interval1day); +----------------------------------------+ |date_sub(current_date,interval1day)| +----------------------------------------+ |2010-01-17| +----------------------------------------+ 1rowinset(0.00sec) MySQL>selectdate_sub(current_time,interval1day); +----------------------------------------+ |date_sub(current_time,interval1day)| +----------------------------------------+ |NULL| +----------------------------------------+ 1rowinset,1warning(0.00sec)
MySQL Date函数 4、时间间隔
MySQL>selectdatediff('2010-01-18','2010-01-17'); +-------------------------------------+ |datediff('2010-01-18','2010-01-17')| +-------------------------------------+ |1| +-------------------------------------+ 1rowinset(0.00sec) MySQL>selecttimediff('2010-01-1812:00','2010-01-1711:00'); +-------------------------------------------------+ |timediff('2010-01-1812:00','2010-01-1711:00')| +-------------------------------------------------+ |25:00:00| +-------------------------------------------------+ 1rowinset(0.00sec)
MySQL Date函数 5、时间转换
MySQL>selecttime_to_sec('25:00:00'); +-------------------------+ |time_to_sec('25:00:00')| +-------------------------+ |90000| +-------------------------+ 1rowinset(0.00sec) MySQL>selectsec_to_time(90000); +--------------------+ |sec_to_time(90000)| +--------------------+ |25:00:00| +--------------------+ 1rowinset(0.00sec)
以上的相关内容就是对MySQL Date函数的介绍，望你能有所收获。
【编辑推荐】
- MySQL数据库安全设置的操作流程使用MySQL管理心得讲述MySQL基本操作，新手入门宝典MySQL 操作日志查看的实际操作步骤与代码MySQL游标的使用笔记大全