/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

3 votes174 views2 answers
Host is not allowed to connect to this mysql server
SQL
21 votes166 views6 answers
Docker run mysql
SQL
0 vote188 views1 answer
Psotgres multiple values
SQL
2 votes167 views1 answer
Oracle drop table free up space
SQL
1 vote167 views1 answer
Sql eliminare un record
SQL
0 vote164 views1 answer
Linux upload database to mysql
SQL
0 vote163 views1 answer
Oracle index hint
SQL
0 vote165 views1 answer
Sqldf change user
SQL
16 votes171 views6 answers
Mysql find and replace
SQL
0 vote165 views2 answers
Insert into
SQL

Share