Search
 
SCRIPT & CODE EXAMPLE
 

SQL

how to get 30 days previous date in mysql

SELECT * from customers where lastLedgerCreated<=CURDATE() - INTERVAL 30 DAY
Comment

PREVIOUS NEXT
Code Example
Sql :: sql server date format yyyy-MM-ddThh:mm:ss 
Sql :: mysql timestamp format 
Sql :: postgressql uuid 
Sql :: list all tables in postgres 
Sql :: mysql remove first and last character from string 
Sql :: como saber si tengo mysql instalado 
Sql :: sql reverse order of results 
Sql :: oracle shrink table 
Sql :: MYSQLI_ASYNC 
Sql :: sql format time 
Sql :: how to drop database name in postgresql 
Sql :: set value to null sql 
Sql :: SQL Less Than or Equal to Operator 
Sql :: how to change db owner postgres 
Sql :: how to import pymysql through jupyter notebook for windows 
Sql :: role "postgres" does not exist 
Sql :: mysql root permission denied lost 
Sql :: object dependencies in oracle 
Sql :: how to delete a table in mysql 
Sql :: drop function in sql 
Sql :: get sum sqlite android 
Sql :: how to count the number of rows in sql 
Sql :: sqlite3 update select 
Sql :: sql online compiler 
Sql :: t-sql random number for each row 
Sql :: how to get previous year from sysdate in oracle 
Sql :: get triggers by query 
Sql :: warning: mysqli::__construct(): (hy000/2002): 
Sql :: truncate psql 
Sql :: sql where contains part of string 
ADD CONTENT
Topic
Content
Source link
Name
2+4 =