/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

4 votes163 views5 answers
Get last query in codeigniter 4
SQL
22 votes195 views4 answers
Mysql date format
SQL
0 vote149 views1 answer
Psql no such file or directory
SQL
0 vote162 views1 answer
Alter database name script
SQL
1 vote128 views1 answer
Alter table column size oracle
SQL
17 votes138 views6 answers
Change column name in sql
SQL
0 vote170 views1 answer
How to connect to xampp sql server on windows cmd
SQL
4 votes156 views3 answers
NOT NULL SQL
SQL
1 vote131 views1 answer
Oracle stop job
SQL
1 vote164 views1 answer
Ora-01109 database not open in oracle 19c
SQL

Share