2 Replies Latest reply: Oct 18, 2012 11:26 AM by Aaron Loechel RSS

    how to create quarter in mysql database

      DEAR TEAM,

       

       

      I HAVE A TABLE AS

       

       

      SELECT MONTH,YEAR FROM FACT; in mysql database

       

      But plz tell me the command by which i can devide the MONTH or Year Columns in 4 Quarter[Q1(jan-march),Q2(april-jun),Q3(july-sep),Q4(oct-dec)] .

       

      Regards,

      Rahul