DATE_FORMAT('2021-06-01 00:35:17', '%Y-%m-%d %H:%i:%S')
例子:
SELECT
bill_id,
id_crtf,
id_lot_smp,
id_purchse,
modify_date,
order_num,
pack_id,
product_id,
product_type,
provider_id,
putin_plan_date,
putin_plan_id,
shopsign,
source_wprovider_id,
stove_num,
wprovider_id
FROM
xxxxxxxxa5555
WHERE
modify_date >= DATE_FORMAT(
'2021-06-01 00:35:17',
'%Y-%m-%d %H:%i:%S'
)
AND modify_date <= DATE_FORMAT(
'2021-06-07 09:35:19',
'%Y-%m-%d %H:%i:%S'
)