how to fetch first day in the quarter year
875438Sep 19 2011 — edited Sep 19 2011Hi,
how can i write a query to fetch the first day in a reporting quarter
for example:-
the first quarter starts from 1st April to 30th june, second quarter starts from 1st july to 30th september, third quarter starts from 1st october to 31st december and fourth quarter starts from 1st Jan to 31st March.
How can i then fetch the first day from these quarters, irrespective of the year. The year can be any year.