/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 vote107 views1 answer
Sql query to select records entered in last 24 hours
SQL
0 vote125 views3 answers
Duplicate row mysql
SQL
0 vote114 views1 answer
Sql constarint
SQL
53 votes292 views6 answers
How to install mysql ubuntu
SQL
14 votes125 views3 answers
Oracle sql limit results
SQL
0 vote125 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote132 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote200 views1 answer
Run mysql xampp shell
SQL
0 vote143 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
1 vote155 views1 answer
Apex run 404
SQL

Share