Skip to content

Instantly share code, notes, and snippets.

@springcome
Last active November 3, 2015 02:14
Show Gist options
  • Save springcome/b4912229a6582eb0df62 to your computer and use it in GitHub Desktop.
Save springcome/b4912229a6582eb0df62 to your computer and use it in GitHub Desktop.
Querydsl Between
-- SQL
-- select * from member
-- where to_char(dt, 'yyyyMMdd') between startDt and endDt
QMember member = QMember.member;
List<Member> list =
select().from(member).where(
member.dt.between(startDt, endDt)).list(member);
List<Member> list =
select().from(member).where(
member.dt.goe(startDt)
, member.dt.lt(endDt)).list(member);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment