常见自定义方法 博客分类： mysql

CREATE DEFINER=`bar`@`%` FUNCTION `statisticalDay`(time datetime) RETURNS varchar(50) CHARSET utf8
    DETERMINISTIC
begin
declare temp varchar(50) DEFAULT '';
select if(hour(time) < 8 or (hour(time)<9 and MINUTE(time)<30) ,DATE_FORMAT(date_add(time,interval -1 DAY),'%Y-%m-%d') ,DATE_FORMAT(time,'%Y-%m-%d')) into temp;
return temp;
end

select  *  from  t_table where statisticalDay(F_Createime)='2021-03-21'