title: Grouping mysql records fortnightly
body: <p>I want to group the records on its timestamp field Fortnightly. I am doing it weekly now but i want it to be fortnightly also. How do i do that ? Is there a specific way to do this like how we group by weeks using WEEK('timestamp','%d-%m-%Y') function ?</p>
  
  <p>In the below image can you see date 21 and 14 coming up for fortnight 10. Any suggestions ?</p>
  
  <p><img src="https://i.stack.imgur.com/xRJy8.jpg" alt=""></p>