Function for week of the month in mysql

by

AFAIK, there is no standard on the first week of month.

First week of year is the week containing Jan 4th.

How do you define first week of month?

UPDATE:

You’ll need to rewrite your query like this:

SELECT  WEEK(dateField, 5) -
        WEEK(DATE_SUB(dateField, INTERVAL DAYOFMONTH(dateField) - 1 DAY), 5) + 1

so that the year transitions are handled correctly, and the weeks start on Monday.

Otherwise, your query is fine.

More Related Contents:

  1. MySQL: Alternatives to ORDER BY RAND()
  2. MySQL LIKE IN()?
  3. Auto Increment after delete in MySQL
  4. Unioning two tables with different number of columns
  5. NULL in MySQL (Performance & Storage)
  6. In MySQL queries, why use join instead of where?
  7. MySQL Trigger to prevent INSERT under certain conditions
  8. MySQL “NOT IN” query
  9. Importance of varchar length in MySQL table
  10. Stored Procedure with optional “WHERE” parameters
  11. mySQL :: insert into table, data from another table?
  12. Return 0 if field is null in MySQL
  13. MySQL “between” clause not inclusive?
  14. SQLite – ORDER BY RAND()
  15. How to search multiple columns in MySQL?
  16. MySQL – Selecting data from multiple tables all with same structure but different data
  17. Can a stored procedure/function return a table?
  18. Adding a new SQL column with a default value
  19. Selecting all corresponding fields using MAX and GROUP BY
  20. MySQL full text search for words with three or less letters
  21. Multiple Ranks in one table
  22. Create date from day, month, year fields in MySQL
  23. Functions with variable number of input parameters
  24. The difference between ‘AND’ and ‘&&’ in SQL
  25. Can I use a MySQL database with an App Engine application
  26. How can I make an average of dates in MySQL?
  27. What is the best way to generate ranks in MYSQL?
  28. How to implement a Keyword Search in MySQL?
  29. In SQL how do I get the maximum value for an integer?
  30. Get the first and last date of next month in MySQL

Leave a Comment