So my entity has:
@Column(name="TS", nullable=false)
private java.sql.Timestamp timestamp;
My generated MetaModel has:
public static volatile SingularAttribute<MyEntity,Timestamp> timestamp;
I want to select by the Max Timestamp value:
Root<MyEntity> root = query.from(MyEntity.class);
Expression maxExpression = cb.max(root.get(MyEntity_.timestamp));
But I am not allowed because:
max(Expression<N> x)
Create an aggregate expression applying the numerical max operation.<N extends java.lang.Number>
Expression
Of course Timestamp
does not extend Number
.
How can I do a MAX
on a Timestamp
column using the typesafe Criteria API ?
Instead of max one should use CriteriaBuilder.greatest for Timestamp (and for Date, String and other Comparables as well). And if you ever need MIN for Timestamp, then use least method instead
Similar kind of issue can be be faced with less/greater/equal comparisons. Firs one accepts argument that extends Number, second one is for other comparables:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With