Show week start date

[hessodreamy]

I pull out a lot of reports for weekly figures, but is there any way to get the start date for a particulr week number?

 

[r937]

which week numbers are you using? and which day starts your week?

r937.com | rudy.ca

 

[hessodreamy]

for example:

SELECT from_unixtime(uts,'%u') as week_number, count(*) as orders from ordersTable WHERE from_unixtime(uts,'%Y')=2006
GROUP BY from_unixtime(uts,'%u')

Giving
+-------------+--------+
| week_number | orders |
+-------------+--------+
| 18 | 20 |
+-------------+--------+

weeks start on monday.

 

[r937]

SELECT from_unixtime(uts,'%u') as week_number
     , [COLOR=blue]from_unixtime(uts - 
         mod(from_unixtime(uts,'%w')+6,7)
            *86400)  as start_of_week [/color]
     , count(*) as orders 
  from ordersTable 
 WHERE from_unixtime(uts,'%Y')=2006
GROUP 
    BY from_unixtime(uts,'%u')
     , [COLOR=blue]from_unixtime(uts - 
         mod(from_unixtime(uts,'%w')+6,7)
            *86400) [/color]

r937.com | rudy.ca