views:

98

answers:

1
@Entity
@Table(name = "USERS")
public class User {
 @Id
 @GeneratedValue(strategy = GenerationType.AUTO)
 private long id;

 @Column(name = "USERNAME", nullable = false, length = 20)
 private String userName;

 @Column(name = "PASSWORD", nullable = false, length = 10)
 private String password;

 @Column(name = "Date", nullable = false )
 private Date date;
}

How can I select the records which have the date between

  • [now | now-x hours]
  • [now | now-x days]
  • [now | now-x months]
  • [now | now-x years]
A: 

the same way as with the other fields: <= >= or between etc

you can use commons-lang / DateUtils to modify the date.

Salandur