On Thu, Feb 23, 2006 at 13:55:34 -0600, Brandon Metcalf <[EMAIL PROTECTED]> wrote: > > If I have a column called date with data type timestamp without time > zone I know I can use > > SELECT * FROM table WHERE date < (now()::DATE - 7)::TIMESTAMP;
You can do this without converting to timestamp: SELECT * FROM table WHERE date < current_date - 7; ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
