这是连接oracle数据库的
<select id="selectByTime" resultMap="BaseResultMap">
select * from SEND_CAR_Iwhere ACF_TIME>to_date(#{startTime},'yyyy-mm-dd hh24:mi:ss') and to_date(#{endTime},'yyyy-mm-dd hh24:mi:ss') >ACF_TIME
</select>
这是与mysql数据库连接的
SELECT *
FROM user_user_t
WHERE DATE_FORMAT(crtime,'%Y-%m-%d')
BETWEEN DATE_FORMAT(startTime,'%Y-%m-%d')
AND DATE_FORMAT(endTime,'%Y-%m-%d')
GROUP BY DATE_FORMAT(crtime,'%Y-%m-%d')
ORDER BY MONTH(crtime),DAY(crtime);