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

Question

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.

Answer 1

Yes, you can use them all in a single query.

The only disadvantage I can think of is that using any of the DAY, WEEK or YEAR functions won't be able to use the index on the column the function is applied to, assuming one is present.

If you're having issues relating to date formatting, you should get familiar with:

• DATE_FORMAT
• STR_TO_DATE