Home > Software design >  PostgreSQL - Deleting data that are older than 3 Months command
PostgreSQL - Deleting data that are older than 3 Months command

Time:05-06

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' 
  • Related