PostgreSQL - Deleting data that are older than 3 Months command
Please help me guys with this i cant find the command.
CodePudding user response:
please, try this command
DELETE from table WHERE to_timestamp(last_login) < NOW() - INTERVAL '3 months'