Date Minus Days
I am making a project intranet page and I need to pull up a section of tasks that have been completed in the last week and currently have it only pulling the last 10 items on the webpage with the following code, any more efficient suggestions?
SELECT *
FROM tasks
WHERE complete = 'y' AND
comp_date < current_timestamp
SELECT *
FROM tasks
WHERE complete = 'y' AND
comp_date < current_timestamp
