[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [Newsgroup Home]
[news.eclipse.rt.eclipselink] Re: Dealing with separate DATE and TIME fields in database, need TIMESTAMP

You could add query keys in EclipseLink for the DATE and TIME fields, but you would have to query on them separately, not as a timestamp. JPQL does not have a TIMESTAMP function, so you would have to query the date and time as separate fields instead.

You could use EclipseLink Expressions or SQL for your query. Expressions have a getFunction() API to access any database function, you can also define your own ExpressionOperators.


-- James