sql中运用时间

哈哈之王

于 2022-10-09 14:07:50 发布

阅读量417

点赞数

分类专栏： mysql Mybatis 文章标签： sql 数据库

本文链接：https://blog.csdn.net/m0_46570170/article/details/127225656

版权

mysql 同时被 2 个专栏收录

12 篇文章 0 订阅

订阅专栏

Mybatis

10 篇文章 0 订阅

订阅专栏

select
        *
from questionnaire
where
      customer_id = 1
  and category_id = 1
  and status=2 and is_deleted = 0 and to_days(create_time) = to_days(now());

select * from questionnaire where to_days(create_time) = to_days(now());


select
       *
from questionnaire
where customer_id = 1002 and category_id = 1000  and is_deleted = 0
  and to_days(create_time) = to_days(now())


select count(subject_id)
from subject_customer
where is_deleted = 0
  and customer_id = 1002
  and questionnaire_id = 1086
  and  category_id= 1000
  and to_days(create_time) = to_days(now())

今天操作数据库的用户