PostgreSQL: Syntax error at or near "14" when trying to run a delete query

Question

First question here!

So I have a table with a row like this:

created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP

I would like to run a query that delete all the data in my table older than 14 days.

This is my query:

DELETE FROM customers WHERE timestamp < NOW() - INTERVAL 14 DAY;

This is the error: syntax error at or near "14"

Anyone knows why this is not working and/or how could I achieve my goal??

Many thanks!!

Tryph · Accepted Answer · 2020-09-18 08:57:19Z

1

The interval value must be quoted:

DELETE FROM customers WHERE created_at < NOW() - INTERVAL '14 DAYS';

answered Aug 26, 2020 at 9:49

Tryph

6,27935 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

@LucaTomarelli: Instead of addin a "Thanks!" comment, it is custom here to upvote and/or accept an answer if it helped...

wildplasser · Accepted Answer · 2020-08-26 09:50:48Z

0

DELETE FROM customers WHERE created_at < NOW() - INTERVAL '14 DAY';

answered Aug 26, 2020 at 9:50

wildplasser

44.5k9 gold badges72 silver badges116 bronze badges

@LucaTomarelli: Instead of addin a "Thanks!" comment, it is custom here to upvote and/or accept an answer if it helped...

Tom · Accepted Answer · 2020-09-18 09:24:01Z

0

Another variation on the existing answers (possibly easier to remember):

DELETE FROM customers WHERE timestamp < NOW() - '14 days'::interval;

answered Sep 18, 2020 at 9:24

Tom

5906 silver badges9 bronze badges