Guest User

Untitled

a guest
Jan 21st, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. /* 自分で定義したDateRange型から、where条件を生成したい */
  2.  
  3. -- before
  4. select * from table
  5. where
  6. update_time between /*range.getStart()*/'2011-01-01' and /*range.getEnd()*/'2011-12-31'
  7.  
  8. -- after
  9. select * from table
  10. where
  11. /*=QueyUtil.between("update_time",range)*/
Add Comment
Please, Sign In to add comment