from_unixtime(b.addtime, “%H:%i:%s”) as 时间

    %H:%i:%s 为24小时制
    %h:%i:%s 为12小时制

    1. select b.mch_id                                专柜id,
    2. c.name                                  专柜名称,
    3. b.order_no                              订单号,
    4. if(b.is_offline, "到店自提", "邮寄")       as 配送方式,
    5. if(b.is_supplement, "是", "否")       as 是否补录,
    6. a.transaction_goods_name                商品名称,
    7. e.name                                  一级分类,
    8. f.name                                  二级分类,
    9. a.num                                   购买数量,
    10. b.total_price                           订单总价,
    11. b.pay_price                             微信支付,
    12. b.store_card_pay_price                  购物卡,
    13. b.mika_coupon_discount                  优惠券,
    14. b.member_price_discount                 会员折扣,
    16. #        c.name                                  商品分类,
    17. from_unixtime(b.addtime)             as 日期,
    18. from_unixtime(b.addtime, "%H:%i:%s") as 时间
    19. from hjmallind_order_detail as a
    20. left join hjmallind_order as b on a.order_id = b.id
    21. left join hjmallind_mch as c
    22. on b.mch_id = c.id
    23. left join hjmallind_goods as d on a.goods_id = d.id
    24. left join hjmallind_true_goods_category as e on d.new_goods_cat_first = e.id
    25. left join hjmallind_true_goods_category as f on d.new_goods_cat_second = f.id
    28. where b.is_pay = 1
    29. and from_unixtime(a.addtime, "%H:%i:%s") >= "00:00:00"
    30. and from_unixtime(a.addtime, "%H:%i:%s") <= "09:30:59"
    31. and b.addtime >= 1640966400
    32. and b.addtime <= 1654012799
    34. # order by a.id desc
    36. # select  count(*) from hjmallind_order where addtime >= 1640966400 and is_pay = 1;
    38. # // 早上：00:00:00-09:30:59  晚上：22:00:00-23:59:59
    39. # 字段：
    40. # 商品门店、商品名称、商品分类、数量、金额（实付金额、券、365优惠金额）  邮寄/自提
    43. # show create table hjmallind_order