Getting first day of the week in MySql using Week No

by

This is an accurate way of getting the first day of the week and the last day of the week based on the current date:

adddate(curdate(), INTERVAL 1-DAYOFWEEK(curdate()) DAY) WeekStart,
adddate(curdate(), INTERVAL 7-DAYOFWEEK(curdate()) DAY) WeekEnd

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. Error related to only_full_group_by when executing a query in MySql
  3. SQL split values to multiple rows
  4. Get records with max value for each group of grouped SQL results
  5. How to reset AUTO_INCREMENT in MySQL
  6. How to declare a variable in MySQL?
  7. How to populate a table with a range of dates?
  8. MySQL Query GROUP BY day / month / year
  9. MySQL Cannot Add Foreign Key Constraint
  10. Grouping into interval of 5 minutes within a time range
  11. SQL counting all rows instead of counting individual rows
  12. Convert timestamp to date in MySQL query
  13. Update a column value, replacing part of a string
  14. MySQL Like multiple values
  15. In MySQL, should I quote numbers or not?
  16. MySQL add days to a date
  17. mysql dynamic query in stored procedure
  18. MySQL combine two columns into one column
  19. Check for x consecutive days – given timestamps in database
  20. MySQL Insert Into from one Database in another
  21. MySQL: LIMIT by a percentage of the amount of records?
  22. MySQL multiple columns in IN clause
  23. How to select one row randomly taking into account a weight?
  24. GROUP BY – do not group NULL
  25. Composite key as foreign key (sql)
  26. MySQL 1062 – Duplicate entry ‘0’ for key ‘PRIMARY’
  27. ALTER table – adding AUTOINCREMENT in MySQL
  28. MySQL Select minimum/maximum among two (or more) given values
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment