Prathamesh Kurade
Reputation: 97
PostgreSQL - Deleting data that are older than 3 Months command
PostgreSQL - Deleting data that are older than 3 Months command
Please help me guys with this i cant find the command.
Upvotes: 0
Views: 712
Answers (1)
K.D
Reputation: 132
Try this command:
DELETE from table WHERE to_timestamp(last_login) < NOW() - INTERVAL '3 months'
Upvotes: 1
Related Questions
- how do i delete records older than 90 days from a table in postgres
- I need to delete rows that are newer than 2019
- PostgreSQL: how to delete rows from a table older than 2 months?
- How to delete all the records a particular table, but except last 6 months data
- Delete all data before two months from table in SQL Server
- Delete records in PostgreSQL, older than X days, where X is a parameter
- Delete Records past 6 month Oracle
- Postgresql: How to delete rows from table constrained by date?
- SQL - Removing rows before a specific date
- How to delete data older than particular month specified in oracle sql