/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 vote166 views1 answer
Parsing float to int in mysql
SQL
-1 vote216 views1 answer
Search all sql tables for a value
SQL
0 vote186 views1 answer
Import excel to sql
SQL
0 vote204 views1 answer
Database db connection string format
SQL
0 vote181 views1 answer
Set engine to innodb
SQL
2 votes161 views1 answer
When matched in sql server
SQL
7 votes169 views4 answers
Lowest salary in sql
SQL
0 vote176 views1 answer
How to check even or odd in sql
SQL
0 vote175 views1 answer
Sql query to force the database to be drop
SQL
1 vote167 views1 answer
Show table columns
SQL

Share