Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Quarters between dates?

Quarters between dates?

From: llevity <llevity_at_gmail.com>
Date: 14 Jun 2005 07:47:29 -0700
Message-ID: <1118760449.085223.62240@o13g2000cwo.googlegroups.com>


Is there a way to determine how many quarters have elapsed between two dates? I'm trying to come up with a clever way of doing it, rather than loops and if statements.

An example is I have a start date of December 31st, 1999. An end date of January 2nd 2000. This date range spans 2 quarters. If the start date was Dec 1st, it would only span one quarter.

Any ideas? Received on Tue Jun 14 2005 - 09:47:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US