/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

8 votes178 views1 answer
Mysql dump restore
SQL
13 votes139 views2 answers
Sqlite rename column
SQL
0 vote135 views1 answer
Create a table from one field of another table
SQL
0 vote146 views1 answer
Database schema for mcqs type exam in sql
SQL
0 vote147 views1 answer
Storing RGBA in mysql db
SQL
11 votes141 views3 answers
How to get last row of table in sql
SQL
13 votes136 views5 answers
Alter table query sql server change column
SQL
0 vote165 views1 answer
Drop all data from tables
SQL
5 votes134 views1 answer
Mysql select greater than yesterday
SQL
11 votes142 views6 answers
Mysql else if
SQL