Hi, I have tried to use this query: "SELECT count(smsc_id) as total,
insertdate FROM momtbak WHERE insertdate BETWEEN
DATE_SUB(CURRENT_DATE(), INTERVAL 4 WEEK) AND CURRENT_DATE() group by
week(date_format(insertdate,'%Y-%m-%d'),3)" to group records in the
last 4 weeks by week. But the result returns this list:
144
2008-11-06 07:00:24
1883
2008-11-10 07:00:06
1645
2008-11-17 11:59:46
2476
2008-11-24 21:54:11
1015
2008-12-01 20:45:43
The expected result is the date shown above is the weeknumber. What do I miss
here? TIA
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
