weixin_43700889的博客

SELECT concat( concat(timestampdiff(SECOND,IFNULL(‘2021/10/31 15:50:21’,NOW()),‘2021/12/15 14:55:23’) div 86400,‘天’), concat(timestampdiff(SECOND,IFNULL(‘2021/10/31 15:50:21’,NOW()),‘2021/12/15 14:55:23’) mod 86400 div 3600,‘时’), concat(timestampdiff(SECON

CREATE FUNCTION udf_remove_end_zero( i_int_srt varchar(50) – 数值字符串 ) RETURNS varchar(50) CHARSET utf8 COMMENT ‘去除数值字符串末尾的0’ BEGIN DECLARE result varchar(50) DEFAULT ‘’; DECLARE v_nums int; DECLARE tmp_str varchar(1); SET result = i_int_srt; S

DELIMITER DROPFUNCTIONIFEXISTSudfremoveendzero DROP FUNCTION IF EXISTS udf_remove_end_zeroDROPFUNCTIONIFEXISTSudfr​emovee​ndz​ero CREATE FUNCTION udf_remove_end_zero (i_int_srt varchar(50) – 数值字符串 ) RETURNS varchar(50) CHARSET utf8 COMMENT ‘去除数值字符串末尾的0’ BE

create or replace function udf_year_lastweek( i_year varchar2 – 年。如2015 ) return varchar2 is v_year varchar2(6) ; v_date_temp VARCHAR(8); begin v_date_temp:= (substr(i_year,1,4)||‘1231’); SELE...

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(‘func_get_split_string_total’) AND type in (N’FN’, N’IF’, N’TF’, N’FS’, N’FT’)) DROP FUNCTION func_get_split_string_total GO /****** O...