当选中的时间打印的时候显示:
格式化一下:
dateFormat(dateData) {var date = new Date(dateData)var y = date.getFullYear()var m = date.getMonth() + 1m = m < 10 ? ('0' + m) : mvar d = date.getDate()d = d < 10 ? ('0' + d) : dconst time = y + '-' + m + '-' + dreturn time}
查询sql:
@Query(value = "select * from books where date_format(【数据库表时间的字段】,'%Y-%m-%d') = ?1", nativeQuery = true)List<Book> findBookByDate(String dateStr);