/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 vote287 views2 answers
Begin transaction sql
SQL
0 vote214 views1 answer
Commit transaction sql
SQL
0 vote215 views1 answer
Sql change date format
SQL
0 vote261 views1 answer
Find and replace query in wordpress\
SQL
0 vote231 views1 answer
Sql tablo hangi sp de
SQL
14 votes215 views3 answers
Delete all records from table except sql
SQL
0 vote256 views1 answer
Tsql cte in a transaction
SQL
0 vote171 views2 answers
Jupyter notebook connect to database
SQL
0 vote212 views1 answer
Change data type in mysql
SQL
17 votes205 views6 answers
Sql current date
SQL

Share