/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 votes397 views1 answer
Sql delete multiple conditions
SQL
2 votes353 views2 answers
Mysql date range
SQL
10 votes359 views4 answers
Mysql one week ago
SQL
0 vote376 views1 answer
Sql cnvert bit to nvarchar
SQL
7 votes367 views1 answer
Safe update mysql
SQL
8 votes369 views10 answers
Sql
SQL
-1 vote319 views10 answers
Delete Query in SQL Server
SQL
2 votes403 views3 answers
Mysql kill
SQL
15 votes354 views4 answers
T-sql drop function if exists
SQL
4 votes362 views2 answers
Mysql alter table set column unique
SQL