SELECT
ta_out_role.msg_id,ta_out_role.system_code,
ta_out_role.role_id,
ta_out_role.role_name,
ta_out_role.oper_type,
ta_out_role.create_tm
FROM
uupm.ta_out_role
WHERE
DATEDIFF(NOW(), create_tm) < 2
AND DATEDIFF(NOW(), create_tm) >= 0
AND system_code = 'OETS_CODE';