Re: how can I select a period of a quarter(year)

From: Gerard M. Averill <e-mail.address_at_my.sig>
Date: Thu, 08 Apr 99 19:43:29 GMT
Message-ID: <7ej0k8$h8m$1@news.doit.wisc.edu>

In article <7efs8g$633$1_at_nnrp1.dejanews.com>, tacheles <tacheles_at_my-dejanews.com> wrote:
>I know how to select a week or a month but I cannot find a tag to select a
>quarter of year. Is there a special tag for my query?
>thanks in advance.

select to_char(sysdate, 'Q/YYYY') from dual;

TO_CHAR(SYSDATE,'Q/YYYY')

---

2/1999 1 row selected.

Hope this helps.
Gerard

---

Gerard M. Averill, Researcher
CHSRA, University of Wisconsin - Madison GAverill<at>chsra<dot>wisc<dot>edu Received on Thu Apr 08 1999 - 14:43:29 CDT