/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 vote203 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote185 views1 answer
Postgresql delete limit
SQL
0 vote171 views1 answer
Mysql workbench indent formatting
SQL
2 votes189 views2 answers
Laravel query builder toSql
SQL
0 vote189 views1 answer
PGSQL dynamic table name
SQL
13 votes210 views2 answers
Oracle inner join
SQL
6 votes180 views2 answers
If not exists insert sql
SQL
1 vote181 views2 answers
Postgresql list columns
SQL
0 vote186 views1 answer
Mysql a from on this page has
SQL
2 votes205 views1 answer
Oracle trace file
SQL

Share