About CURRENT_DATE

manual

Date and Time in JPQL and Criteria Queries

Shows how date and time can be used in JPQL queries.... server when the query is executed: CURRENT_DATE - is evaluated to the current date (a java.sql.Date ...

 
issue

Issue with UPPER ?

Hi, Assuming those queries which are all the same except the UPPER calls: ... NULL ) AND ( $2 . austritt <= CURRENT_DATE ) ) ) ) AND ( ( ... NULL ) AND ( $2 . austritt <= CURRENT_DATE ) ) ) ) AND ( ( ...

 
manual

FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... CHARACTER_LENGTH, CLASS, COALESCE, CONCAT, COUNT, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP,DELETE, DESC, DISTINCT, ELSE, ...