Skip to content

Instantly share code, notes, and snippets.

@heyost

heyost/get_past_1_week_and_1_week_present_on_MySQL.sql

Created April 2, 2016 08:51
Show Gist options
  • Save heyost/eb656e13bc6e23d38050fe2bf160d571 to your computer and use it in GitHub Desktop.
Save heyost/eb656e13bc6e23d38050fe2bf160d571 to your computer and use it in GitHub Desktop.
Download ZIP
Get some week between date in MySQL
Raw
get_past_1_week_and_1_week_present_on_MySQL.sql
# 1 week past
SELECT DATE_ADD("2016-02-04", INTERVAL(-6-DAYOFWEEK("2016-02-04")) DAY) AS start, DATE_ADD("2016-02-04", INTERVAL(0-DAYOFWEEK("2016-02-04")) DAY) AS FINISH
# present week
SELECT DATE_ADD("2016-02-04", INTERVAL(1-DAYOFWEEK("2016-02-04")) DAY) AS start, DATE_ADD("2016-02-04", INTERVAL(7-DAYOFWEEK("2016-02-04")) DAY) AS FINISH
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment