Hi all,

I have a abstract BaseEntity(annotated with MappedSuperclass), and this parent class has properties as below:
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "create_time")
private Date createTime;
@Temporal(TemporalType.TIMESTAMP)
@Column(name = "last_update_time")
private Date lastUpdateTime;

and as you expected there are methods annotated with PrePersist and PreUpdate. I want to count the number of rows of a derived entity from the above class with respect to last_update_time for per day. After the query I should get the following table

==================================
|____Count_____|_________Day__________|
==================================
|_____x________|firstUpdateDayInTable(min)|
--------------------------------------------
|_____y________|__________d1__________|
--------------------------------------------
|_____z________|__________d2__________|
--------------------------------------------
______-________|__________-___________
--------------------------------------------
______-________|__________di___________
--------------------------------------------
______-________|__________-___________
--------------------------------------------
|_____t________|lastUpdateDayInTable(max)|
--------------------------------------------

such that, firstUpdateDayInTable < d1 < d2 < di < lastUpdateDayInTable. Do you have any idea?

Thank you for your interest.