select * from dynamic where d_created >= current_timestamp - interval ' 7 day ' 转载于:https://www.cnblogs.com/wangbin/archive/2010/12/09/1900910.html