How to format quarter date

• • Reply

  18 years ago

  by simflex

  sim Okeh

  usa, United States

  Joined 18 years ago

  I like to write a query that would return quarterly results.
  I need to able to display data like:
  

  
    1Q              2Q           3Q            4Q
  mar apr may;    jun jul aug   sep oct nov   dec jan feb.
  

  
  This way, i could get data for any month and it would fall under a particular quarter.
  My company's quarter starts in March.
  This is not a report rather an SQL statement.
  I am having problem with the quarter date formatting.
  I truly appreciate anybody's help.
  

  Report abuse