Dates and Weeks

[visualAd]

Again, in MySql you can use a function which does this in the SQL query:

SELECT DATE_FORMAT(date, '%U');

The DATE_FORMAT() function is documented fully here.