Loading
Java Persistence API (JPA) Extensions Reference for EclipseLink, Release 2.4
  Go To Table Of Contents
Contents
 Search
Other Searches
 PDF
PDF
Comments
Comments


EXTRACT

Use EXTRACT to retrieve the date portion of a date/time value.


Usage

The EXTRACT function is database independent, but requires database support


Examples

Example 3-5 shows how to use this JPQL extension.

Example 3-5 Using EXTRACT EQL

EXTRACT(YEAR, e.startDate)


See Also

For more information, see:

Comments powered by Disqus