/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 vote112 views1 answer
Mysql wsrep ls
SQL
22 votes125 views3 answers
Remove all records from table mysql
SQL
1 vote102 views1 answer
Foreign key constraint in ms sql
SQL
3 votes107 views1 answer
Mysql UPDate with enner join
SQL
0 vote130 views1 answer
Netstat -tln mysql
SQL
4 votes71 views1 answer
And or sql order of operations
SQL
1 vote119 views2 answers
Oracle list partitioned tables
SQL
-1 vote77 views2 answers
On delete set default sql server
SQL
0 vote126 views4 answers
Mysql desactivar trigger
SQL
15 votes112 views1 answer
Mysql int range
SQL

Share