How do I get the first day of the week of a date in mysql?

by

If the week starts on Sunday do this:

DATE_ADD(mydate, INTERVAL(1-DAYOFWEEK(mydate)) DAY)

If the week starts on Monday do this:

DATE_ADD(mydate, INTERVAL(-WEEKDAY(mydate)) DAY);

more info

More Related Contents:

  1. MySQL SELECT WHERE datetime matches day (and not necessarily time)
  2. MySQL Query – Records between Today and Last 30 Days
  3. Select mysql query between date?
  4. How to get an age from a D.O.B field in MySQL?
  5. Compare only day and month with date field in mysql
  6. Recreating a query using INNER JOIN? [duplicate]
  7. How to convert a string to date in MySQL?
  8. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  9. Converting a date in MySQL from string field
  10. MySQL: Select All Dates In a Range Even If No Records Present
  11. Ordering by specific field value first
  12. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  13. CURRENT_DATE/CURDATE() not working as default DATE value
  14. INSERT INTO…SELECT for all MySQL columns
  15. How to select date from datetime column?
  16. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  17. Checking multiple columns for one value
  18. MySQL difference between two rows of a SELECT Statement
  19. MySQL – How to select data by string length
  20. How to select the most recent set of dated records from a mysql table
  21. MySQL date format
  22. Difference in minutes from two time fields in MySQL
  23. quick selection of a random row from a large table in mysql
  24. SELECT query return 1 row from each group
  25. Comma separated string of selected values in MySQL
  26. SELECT INTO Variable in MySQL DECLARE causes syntax error?
  27. MySQL Error: #1142 – SELECT command denied to user
  28. #1292 – Incorrect date value: ‘0000-00-00’ [duplicate]
  29. MySQL cumulative sum grouped by date
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment