Query and dates

[johk02]

Hi,

I have table in a MySQL 4.X database where I store the number of clicks a link has had per day. I am trying to generate report similar to:
2006
Jan
Mon
Tue
Wed
Thur
Fri
Sat
Sun
Mon
Tue
Wed
Thur
Fri
Sat
Sun
etc
Feb
March
etc
etc
2007
Jan
Feb
March
etc
etc

I believe I have to use SELECT MONTH () and YEAR() but I can't get my head around it. The date is stored as 2006-07-04.
Any suggestions would be appreciated.

Cheers
Jonas

 

[FALCONSEYE]

select datename(month, getDate())

will return September

select datename(dw, getDate())

will return Wednesday

hope it helps...

http://www.jetansolutions.com