/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

0 vote128 views1 answer
What is default mysql database password in linux
SQL
4 votes105 views2 answers
Sql vs mysql
SQL
0 vote105 views1 answer
Insert into using contant values and source table columns with sql
SQL
1 vote160 views1 answer
Column with prefix in sql
SQL
0 vote115 views1 answer
Select place default lat long
SQL
0 vote105 views3 answers
Mysql delete if not in another table
SQL
12 votes113 views6 answers
Select distinct
SQL
0 vote118 views1 answer
Mysql Digital Ocean connection problems
SQL
1 vote129 views1 answer
Oracle plan hash value
SQL
0 vote138 views1 answer
How to add a Try/Catch to SQL Stored Procedure
SQL