JPQL Query Discussion

For example datetime field as ‘‘2018-08-22 15:32:20.678’’ but I want to take only date from dateTime. How can we do it in JPQL

Use EXTRACT function provided by EclipseLink, or FUNCTION together with a suitable database function. See full list of supported JPQL functions here.

Sorry,my question is from datetime field as ‘‘2018-08-22 15:32:20.678’’ but I want to take format as “2018-08-22” from dateTime