/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 vote210 views2 answers
Postgres show current role
SQL
3 votes149 views4 answers
Show columns from table
SQL
0 vote186 views1 answer
Exec procedure oracle
SQL
0 vote184 views1 answer
Mysql date minus 1 day
SQL
11 votes214 views3 answers
Sql line numbers
SQL
0 vote199 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote196 views1 answer
Mysql last year
SQL
0 vote209 views1 answer
Sql delete dastabase
SQL
5 votes190 views3 answers
Truncate function in sql oracle
SQL
0 vote188 views1 answer
T-sql update table variale
SQL

Share