根据时间类型查询

@Query(value = " select n.id, n.REAL_NAME name, m.num from " +
"(select CREATEUSER,COUNT(CREATEUSER) num from YCNY_USER_ROUTES where CREATETIME BETWEEN TO_DATE(?1, 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE(?2, 'YYYY-MM-DD HH24:MI:SS') " +
"AND ISDEL = 0 GROUP BY CREATEUSER) m " +
"LEFT JOIN TIN_HR_USERS n on m.CREATEUSER = n.ID",nativeQuery = true)
List<Map<String, Object>> findByCreatetime(String beginTime,String endTime);