kode                  rp                  tanggal

J2110103    12000000    2009-08-10 11:07:08
J2112501    5000000    2009-08-10 11:12:26
J2111401    5000000    2009-08-10 11:13:24
J2113501    5000000    2009-08-10 11:14:19

nah gw pengen select yang tanggal 15 semua. kl pake nativeQuery kan bisa tuh 
make date_format()  nah gmn kl pake JPQL?

ne entity nya

    @Temporal(TemporalType.DATE)
    private Date tanggal;

dan ini DAO nya yg sudah jalan(ga error) tp hasil nya kosong :

@Override
    public List<E> findSendAll() {
        Query q = entityManager.createQuery("SELECT l FROM "+ getEntityName() 
+" l WHERE l.tanggal = :tgl");
        q.setParameter("tgl",new Date(),TemporalType.DATE);
        List<E> listLog = q.getResultList();
        return listLog;
    }








________________________________
From: onsir salman <onsirsal...@gmail.com>
To: jug-indonesia@yahoogroups.com
Sent: Tuesday, 11 August 2009 8:17:34
Subject: Re: [JUG-Indonesia] query di JPA

   

"bs minta sample DAO nya?"

sample yang mana nih?

   


      New Email names for you! 
Get the Email name you&#39;ve always wanted on the new @ymail and @rocketmail. 
Hurry before someone else does!
http://mail.promotions.yahoo.com/newdomains/sg/

Kirim email ke