JPQL에서 datetime을 날짜로 변환하는 방법은 무엇입니까?
질문 이 코드의 문제점은 무엇입니까? @Query(value = "Select " + "date(ivd.trnDatetime) as date, " + "ivd.binNo as bin, " + "ivd.snNo as sn, " + "count(ivd.invoiceNo) as totInvoice, " + "sum(ivd.totSaleAmt) as totSaleAmt " + "from InvoiceData ivd where ivd.status = 1 group by date(ivd.trnDatetime), ivd.binNo, ivd.snNo") List getDailyTransactionReport(); 던진다 java.lang.IllegalArgumentException: org.hibernate.Query..