1//Returns Date time
2//Takes where to add (as in year, month, day, etc) to
3//Takes how much to add
4//Takes a datetime in some different formats
5DATEADD(day, 1, '2017/08/25')
1mysql> select sum(Value) from DemoTable1444 where PurchaseDate between '2019-10-02' and '2019-12-31';