2008-05-13 temporal-relationship SQL select * from book where create_date >= '2007/12/05 10:00:00' AND create_date <= '2008/05/12 10:00:00';