/SQL/How to add amount between date in sql

How to add amount between date in sql

Sql add days to date

//Returns Date time
//Takes where to add (as in year, month, day, etc) to
//Takes how much to add
//Takes a datetime in some different formats
DATEADD(day, 1, '2017/08/25')

How to add amount between date in sql

mysql> select sum(Value) from DemoTable1444 where PurchaseDate between '2019-10-02' and '2019-12-31';

Source: tutorialspoint.com

Similar codes

4 votes205 views4 answers
Rollback in sql
SQL
0 vote196 views2 answers
Sql day from datetime
SQL
-1 vote156 views1 answer
Mysql how to set update or create
SQL
0 vote187 views1 answer
Jooq finding lastest value in table
SQL
0 vote212 views2 answers
Change database postgres
SQL
0 vote253 views1 answer
Cahnge column name apex oracle
SQL
0 vote271 views1 answer
Compare two tables to find unmatched records
SQL
0 vote754 views1 answer
Sql show table name in result
SQL
0 vote288 views2 answers
Disadvantages of stored procedures sql
SQL
1 vote185 views1 answer
Launch sql script from docker in mysql
SQL