/SQL/Mysql date greater than 30 days

Mysql date greater than 30 days

Mysql date greater than 30 days

SELECT * FROM my_table WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)

5

Select row from mysql where date more than 30 days

mysql> delete from DemoTable where UserMessageSentDate < now() - interval 30 DAY;
Query OK, 3 rows affected (0.11 sec)

0

Source: tutorialspoint.com

Similar codes

1 vote192 views1 answer
Copy postgres table from one schema into another
SQL
0 vote189 views1 answer
Complete date is 1 year or not sql server
SQL
1 vote246 views1 answer
Create sqlite database in laravel
SQL
1 vote215 views1 answer
How to unlock table in mysql
SQL
0 vote228 views1 answer
Oracle chain step succeeded
SQL
0 vote207 views1 answer
Postgresql auto increment not working
SQL
2 votes183 views1 answer
Ifnull postgres
SQL
1 vote213 views1 answer
Psql import backup file for windows
SQL
0 vote244 views1 answer
Count column of tables psql
SQL
0 vote211 views4 answers
Restart MySQL
SQL

Share