/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 vote174 views1 answer
Codigo crear tablas sql server
SQL
1 vote160 views2 answers
Insert sqlite
SQL
0 vote147 views1 answer
Json_remove mysql
SQL
0 vote153 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
13 votes142 views2 answers
Check if value is null mysql
SQL
10 votes159 views2 answers
Mysql drop database if exists
SQL
2 votes141 views1 answer
Oracle number to percentage
SQL
0 vote147 views1 answer
Sql change default collation to utf8
SQL
0 vote145 views1 answer
MySql count occurences more than"
SQL
0 vote171 views1 answer
Leftjoin in sql
SQL

Share