/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 vote101 views1 answer
Sql comparison operators
SQL
0 vote129 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote119 views1 answer
Second Step in installing SQL workbench
SQL
3 votes112 views1 answer
Oracle transaction commit rollback example
SQL
0 vote116 views1 answer
Sqlserver now
SQL
48 votes175 views3 answers
Psql create database
SQL
4 votes103 views1 answer
Mysql ip address
SQL
2 votes99 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote121 views3 answers
Mysql keyword search
SQL
2 votes118 views1 answer
Postgresql create schema in specific database
SQL

Share