Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Quarters between dates?
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
![]() |
![]() |