/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

7 votes335 views2 answers
3rd height salary sql
SQL
10 votes316 views4 answers
Join multiple tables in sql
SQL
1 vote255 views1 answer
Sqlite3 read only
SQL
7 votes238 views1 answer
Grant schema permissions postgres
SQL
2 votes266 views5 answers
SQL trigger
SQL
0 vote260 views1 answer
Oracle query archivemode
SQL
0 vote299 views1 answer
Postgres list tables and row counts
SQL
3 votes278 views1 answer
Oracle function return
SQL
1 vote296 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
0 vote283 views1 answer
Mysql edit trigger
SQL

Share