/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 vote160 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote142 views1 answer
How to list function in psql
SQL
7 votes197 views2 answers
Oracle foreign key reference table
SQL
0 vote143 views1 answer
ORA-13717
SQL
1 vote152 views1 answer
SQLSTATE[HY000] [2002]
SQL
0 vote141 views1 answer
Sql server express download
SQL
22 votes214 views4 answers
Mysql date format
SQL
0 vote163 views1 answer
Dockerfile example for Django
SQL
2 votes154 views1 answer
Add new column not null sql server
SQL
3 votes137 views1 answer
Oracle wait
SQL

Share