Search
 
SCRIPT & CODE EXAMPLE
 

SQL

mysql date greater than 30 days

SELECT * FROM my_table WHERE created_at > DATE_SUB(NOW(), INTERVAL 1 DAY)
Comment

PREVIOUS NEXT
Code Example
Sql :: grab all records from one table to another oracle sql 
Sql :: psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" f 
Sql :: timestamp in sqlite 
Sql :: Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 
Sql :: how to alter table name in mysql 
Sql :: django sqlite database 
Sql :: oracle delete last row 
Sql :: postgresql format date dd/mm/yyyy 
Sql :: alter sequence restart with postgresql 
Sql :: generate random data postgresql 
Sql :: check mysql timezone 
Sql :: sql get tables from current database you working with 
Sql :: sql beginning of previous month 
Sql :: mysql show table column full description 
Sql :: nvl postgres 
Sql :: wordpress change user password sql 
Sql :: operator does not exist: integer = text 
Sql :: mysql column start with string 
Sql :: sql server pagination 
Sql :: rows to comma separated values in mssql 
Sql :: connect mysql docker 
Sql :: query string starts with vowels 
Sql :: oracle alter table add not null constraint 
Sql :: check mysql port 
Sql :: sql query length of string the longest 
Sql :: get last record in sql 
Sql :: having vs where 
Sql :: date to string sql 
Sql :: query concatenate 
Sql :: alter tablespace add datafile 
ADD CONTENT
Topic
Content
Source link
Name
6+9 =