ansaurus

Question

Example of using CURRENT_DATE in JPA query

Answer 1

A:

If you are using the Expression Framework there is the Expression currentDateDate() method on the Expression (org.eclipse.persistence.expressions.Expression) object.

jitter 2009-10-28 14:00:52

I'll need to try it but I was really trying to avoid using generic JPA queries to avoid dependance on the persistence provider.

javydreamercsw 2009-10-28 14:43:24

Answer 2

A:

It can be used like so:

Query query = manager
    .createQuery("SELECT c FROM CITIES c WHERE c.founded = CURRENT_DATE");
for (Object city : query.getResultList()) {
  System.out.println(city);
}

...where founded is a temporal type:

  @Column(name = "FOUNDED")
  @Temporal(TemporalType.DATE)
  private Date founded = new Date();

Not a great example, but you get the idea. I'm using Eclipselink 1.1.2

McDowell 2009-10-28 14:50:13

You're really close. I got that far just before seeing your reply. I'm trying to do something likeSelect x from Table x where x.id=1 and (x.lastModified-CURRENT_DATE)>=365I need to use calculation on dates.

javydreamercsw 2009-10-28 15:03:19

Is it possible to do datetime arithmetic using JPA? You'd have to have some function to turn the difference into days (and not minutes or months or millennia, etc.). I am not aware of any such functions. Do the date arithmetic in Java and then just select comparing against the resultant range.

McDowell 2009-10-28 15:13:19

I guess this is a flaw or missing functionality of JPA. I'll have to do it that way I guess. Thanks!

javydreamercsw 2009-10-28 16:01:33

ansaurus

tags:

views:

answers:

Example of using CURRENT_DATE in JPA query

related questions