直接看例子:
oracle,
SELECT
DISTINCT ord.USER_ID
FROM
lvmama_ver.ORD_ORDER ord ,
lvmama_ver.ORD_ORDER_ITEM item
WHERE
ord.ORDER_ID = item.ORDER_ID
AND item.PRODUCT_ID = '183253'
AND (
ord.CREATE_TIME BETWEEN to_date('2017-05-19 00:00:00','yyyy-mm-dd hh24:mi:ss') AND to_date
('2017-05-20 00:00:00','yyyy-mm-dd hh24:mi:ss'));
oracle使用to_date函数。上例中的 between... and 结构也可以改成大于号小于号的结构;
mysql,
SELECT
user_user.user_no
FROM
lvmama_user.user_user
WHERE
user_user.created_date > str_to_date('2017-05-19','%Y-%m-%d')
AND user_user.created_date < str_to_date('2017-05-20','%Y-%m-%d');
mysql使用的是 str_to_date函数。