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