数据库|mysql教程
MYSQL,自定义,函数,返回,两个,间指定,类型,时差
数据库-mysql教程
网趣源码,vscode 修改快捷键,ubuntu 响应屏幕,tomcat获取服务路径,openwrt爬虫脚本,php mysql汉字,seo初学者学习优化,java网站新闻模块,画dedecms模板lzw
该函数在MYSQL下编写，5.1版本测试通过。 函数需要传入三个参数，类型(用于区别应返回时差年、时差月…时差秒)，起始时间(用于计算)，结束时间(用于计算) 无 DELIMITER $$CREATE FUNCTION DateBetween (AType INT, ADateStart DATETIME, ADateEnd DATETIME)R
宗氏家族网站源码,vscode跳到下一行,Ubuntu系统速度,西部数码tomcat管理,javafx和爬虫,php基础教程第四版,火炬开发区网页seo排名lzw
游戏试玩网站源码,ubuntu密码框死机,财务管理爬虫,asort php,泗水seo推广lzw
该函数在MYSQL下编写，5.1版本测试通过。
函数需要传入三个参数，类型(用于区别应返回时差年、时差月…时差秒)，起始时间(用于计算)，结束时间(用于计算)
.CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;}.CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;}.CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;}.CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;}.CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;}.CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;}.CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;}.CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;}.CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;}.CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;}
DELIMITER $$CREATE FUNCTION DateBetween (AType INT, ADateStart DATETIME, ADateEnd DATETIME)RETURNS BIGINTBEGINDECLARE AResult BIGINT DEFAULT -1;/*入参AType INT类型，结果类型 1:年 2:月 3:日 4:小时 5:分钟 6:秒钟 (必须在1-6内，否则结果返回-1)*入参ADateStart DATETIME类型，起始时间 (必须是一个正确的日期参数)*入参ADateEnd DATETIME类型，结束时间 (必须是一个正确的日期参数)*返回值 BIGINT类型，返回起始之间与结束时间的指定时差 (成功返回计算出的时差，失败返回-1)*/IF ADateStart != \ AND ADateEnd != \ AND AType >=1 AND AType <= 6 THEN CASE AType WHEN 1 THEN SELECT TIMESTAMPDIFF(YEAR, ADateStart, ADateEnd) INTO AResult; WHEN 2 THENSELECT TIMESTAMPDIFF(MONTH, ADateStart, ADateEnd) INTO AResult;WHEN 3 THEN SELECT TIMESTAMPDIFF(DAY, ADateStart, ADateEnd) INTO AResult; WHEN 4 THEN SELECT TIMESTAMPDIFF(HOUR, ADateStart, ADateEnd) INTO AResult; WHEN 5 THEN SELECT TIMESTAMPDIFF(MINUTE, ADateStart, ADateEnd) INTO AResult; WHEN 6 THEN SELECT TIMESTAMPDIFF(SECOND, ADateStart, ADateEnd) INTO AResult; END CASE;END IF;RETURN(AResult); END$$
SELECT DateBetween(0, -01-01 00:00:00, -01-01 10:00:00);SELECT DateBetween(1, 2001-01-01, -01-01);SELECT DateBetween(2, -01-01, -12-01);SELECT DateBetween(3, -01-01, -01-31);SELECT DateBetween(4, -01-01 00:00:00, -01-01 10:00:00);SELECT DateBetween(5, -01-01 00:00:00, -01-01 10:00:00);SELECT DateBetween(6, -01-01 00:00:00, -01-01 10:00:00);SELECT DateBetween(7, -01-01 00:00:00, -01-01 10:00:00);
