mysql日期时间函数和数值函数以及其他函数DEMO

来源：互联网发布：如何卸载linux系统编辑：程序博客网时间：2024/06/04 18:01

具体DEMOl如下：

SELECT RAND(),RAND(),RAND(3),RAND(3);

SELECT CEIL(1.3),CEIL(-1.5),CEILING(1.3),CEILING(-1.5);

SELECT CEIL(1.9),CEIL(-1.4),CEILING(1.9),CEILING(-1.4);

SELECT FLOOR(1.3),FLOOR(-1.3),FLOOR(1.9),FLOOR(-1.9);

SELECT TRUNCATE(113.1415926,2),TRUNCATE(113.1415926,-2);

SELECT ROUND(113.1415926),ROUND(-113.1415926),ROUND(113.1415926,2),ROUND(113.1415926,-2);

SELECT NOW(),CURRENT_TIMESTAMP(),LOCALTIME(),SYSDATE();

SELECT CURDATE(),CURTIME(),CURRENT_DATE(),CURRENT_TIME();

SELECT NOW()当前日期和时间,UNIX_TIMESTAMP()unix格式,UNIX_TIMESTAMP(NOW())unix格式,FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()))普通格式,FROM_UNIXTIME(UNIX_TIMESTAMP())普通格式;

SELECT NOW()当前日期和时间,UTC_DATE() UTC日期,UTC_TIME() UTC时间;

SELECT NOW()当前日期和时间,YEAR(NOW())年,QUARTER(NOW())季度,MONTH(NOW())月份,WEEK(NOW())星期,HOUR(NOW())小时,MINUTE(NOW())分钟,SECOND(NOW())秒;

SELECT NOW()当前日期和时间,DAYOFWEEK(NOW())星期第几天,DAYOFMONTH(NOW())月中第几天,DAYOFYEAR(NOW())年中第几天,WEEKOFYEAR(NOW())年中第几个星期;

SELECT NOW()当前日期和时间,EXTRACT(YEAR FROM NOW())年,EXTRACT(QUARTER FROM NOW())季度,EXTRACT(MONTH FROM NOW())月份,EXTRACT(WEEK FROM NOW())星期,EXTRACT(HOUR FROM NOW())小时,EXTRACT(MINUTE FROM NOW())分钟,EXTRACT(SECOND FROM NOW())秒;

SELECT NOW()当前日期和时间,DATEDIFF(NOW(),'2017-2-14')相隔天数,CURDATE()当前日期,ADDDATE(CURDATE(),10)'10天后日期',SUBDATE(CURDATE(),10)'10天前日期';

SELECT CURDATE()当前日期,ADDDATE(CURDATE(),INTERVAL('2,3') YEAR_MONTH )'2年3个月后日期',SUBDATE(CURDATE(),INTERVAL('2,3') YEAR_MONTH )'2年3个月前日期';

SELECT CURTIME()当前时间,ADDTIME(CURTIME(),10)'10秒后时间',SUBTIME(CURTIME(),10)'10秒前时间';

SELECT VERSION()数据库版本,DATABASE()数据库名称,USER()当前用户;

SELECT INET_ATON('192.168.1.123')数字,INET_NTOA(3232235899)IP地址;

0 0