/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

0 vote143 views1 answer
Mysql show foreign keys column
SQL
0 vote113 views4 answers
How to drop all tables in sql
SQL
0 vote123 views1 answer
Sql server create constraint
SQL
0 vote99 views1 answer
Events not working db
SQL
28 votes101 views4 answers
Mysql delete database
SQL
0 vote103 views3 answers
CONTACT FORM SQL
SQL
0 vote99 views1 answer
Show specific events on mysql
SQL
0 vote103 views1 answer
Procedures sql insert mysql
SQL
0 vote111 views1 answer
Drop index in sql
SQL
1 vote103 views3 answers
Execute sp in sql server
SQL

Share