Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Can i get a quarter from the date data type
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