How to convert number of week into date?

by

In MySQL the STR_TO_DATE() function can do the trick in just one line!

Example: We want to get the date of the Tuesday of the 32th week of the year 2013. 

SELECT STR_TO_DATE('2013 32 Tuesday', '%X %V %W');

would output:

'2013-08-13'

I think this is the best and shortest solution to your problem.

More Related Contents:

  1. MySQL Query GROUP BY day / month / year
  2. Error in MySQL when setting default value for DATE or DATETIME
  3. Difference between two dates in MySQL
  4. MySQL Query to select data from last week?
  5. Datetime equal or greater than today in MySQL
  6. Set NOW() as Default Value for datetime datatype?
  7. Group mysql query by 15 min intervals
  8. SQL Query to show nearest date?
  9. How to get current date & time in MySQL?
  10. how to cast the hexadecimal to varchar(datetime)?
  11. Get total hours worked in a day mysql
  12. MySQL: Insert datetime into other datetime field
  13. Should I use the datetime or timestamp data type in MySQL?
  14. Delete all Duplicate Rows except for One in MySQL? [duplicate]
  15. How do you set a default value for a MySQL Datetime column?
  16. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  17. MySQL – Operand should contain 1 column(s)
  18. How to get the difference in years from two different dates?
  19. Restore table structure from frm and ibd files
  20. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  21. mysql pivot/crosstab query
  22. UNION query with codeigniter’s active record pattern
  23. Error Code: 1406. Data too long for column – MySQL
  24. Using Count to find the number of occurrences
  25. Is there any reason to worry about the column order in a table?
  26. Checking a table for time overlap?
  27. Does mysql have the equivalent of Oracle’s “analytic functions”?
  28. MYSQL select DISTINCT values in two columns
  29. Replace null with 0 in MySQL
  30. ORDER BY alphabet first then follow by number

Leave a Comment