mysql 日期数据没有也要显示值

最新推荐文章于 2023-04-30 13:46:56 发布

2333!!!!!

最新推荐文章于 2023-04-30 13:46:56 发布

阅读量222

点赞数

分类专栏： mysql 文章标签： mysql Powered by 金山文档

本文链接：https://blog.csdn.net/weixin_46564011/article/details/129087303

版权

mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

        set @endDates=(date_format( (select data_time from zkyq_efe.ele_enterprise_data as maxed
                        where maxed.enterprise_id = #{genericIDAndDateVO.id}
                        and to_days(maxed.data_time) = to_days(#{genericIDAndDateVO.date})
                        order by data_time desc limit 1),'%Y-%m-%d %H:%i:00'));

        set @changeDates:= date_add(@endDates,interval 15 minute );

        set @dates1=date_sub((date_format(@endDates ,'%Y-%m-%d %H:%i:00')),interval 9 hour);

    
        select @changeDates:=date_sub(@changeDates,interval 15 minute ) as cDds from zkyq_efe.ele_enterprise_data  as eed2
        where  eed2.enterprise_id = #{genericIDAndDateVO.id} order by cDds desc limit 36