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 -> Can i get a quarter from the date data type

Can i get a quarter from the date data type

From: Parvinder Singh <parora_at_questone.com>
Date: Mon, 13 Dec 1999 09:50:22 GMT
Message-ID: <3854C184.1BBDBF29@questone.com> 





Hi all



    I have got a small doubt ...can i get  the quarter value with
respect to a month from the field which is of the data type DATE
for e.g


month table (01-Jan-99,01-Apr-99)


now the quarter values with respec to jan and apr are q1.1999 and
q2.1999 can we have that from the field itself ...in other words do we
have any date format which will give us the corresponding quarters of
the date



Thanks & Regards


~Parvinder




P.S : Also reply to parora_at_questone.com


Received on Mon Dec 13 1999 - 03:50:22 CST












Original text of this message













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