use newdb;
select * from superstore;
select `Order Date`, subdate(`Order Date`, INTERVAL 20 DAY) as MaxDeliveryDate from superstore;
select `Order Date`, date_sub(`Order Date`, INTERVAL 20 DAY) as NewColumn from superstore;
select CURRENT_DATE, CURRENT_TIME, Now() as CurrDateTime;
select day(CURRENT_DATE) as CurrDay, month(CURRENT_DATE) as CurrMonth, year(CURRENT_DATE) as CurrYear;
select hour(CURRENT_TIME) as CurrHour, minute(CURRENT_TIME) as CurrMin, second(CURRENT_TIME) as CurrSecond;

select `Order Date`, `Ship Date`, datediff(`Ship Date`,`Order Date`) as Diff_in_Days from superstore;