java javascript jsp查詢指定用戶所有的微博

select?*?from?t_weiboinfo?t?where?t.createdate?between?sysdate-5/24?and?sysdate;

//?最近1天的info

select?*?from?t_weiboinfo?t?where?t.createdate?between?sysdate-1?and?sysdate;

//?最近1周的info

select?*?from?t_weiboinfo?t?where?t.createdate?between?sysdate-7?and?sysdate;