/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

2 votes339 views1 answer
Oracle find unusable indexes
SQL
19 votes351 views4 answers
Rename database in sql
SQL
9 votes345 views3 answers
Show table columns mysql command line
SQL
4 votes487 views6 answers
Laravel jwt
SQL
0 vote362 views1 answer
Oracle service name view
SQL
2 votes407 views1 answer
Find column in all stored procedures sql server
SQL
1 vote381 views1 answer
Base64 encode sql server
SQL
2 votes367 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
2 votes332 views1 answer
Oracle table size
SQL
1 vote369 views3 answers
Postgresql get difference between two dates
SQL

Share