sql get current week start date and end date
xxxxxxxxxx
SELECT CURDATE() - INTERVAL WEEKDAY(CURDATE()) DAY AS startweek;
SELECT CURDATE() + INTERVAL (6-WEEKDAY(CURDATE())) DAY AS endweek;
xxxxxxxxxx
DateAdd(day, (-1* (DatePart(weekday, TIMESTAMP) % 7)) + 2, TIMESTAMP)
-- If first day is sunday in SQL