Using DAY(), WEEK(), and YEAR() at one query

i using MySQL Query for my task. And I interested using Date and time function. can i use DAY(), WEEK(), and YEAR() at one query?

SELECT Object 
  FROM table 
 WHERE DAY(date) BETWEEN 1 AND 7 
GROUP BY WEEK(date, 1), YEAR(date)

i want do this bcoz i'm worry if sometimes my program have an error because of the date setting and not recognize some date.please give me an input.

1
задан klox 8 September 2010 в 02:18
поделиться