quarter
get number of quarter of year from a datetime
quarter
(in dt datetime);
Description
quarter takes a datetime and returns
an integer containing a number representing the quarter of year of the datetime.
Parameters
dt –
A datetime.
Return Values
An INTEGER containing number of the quarter of year.
Examples
Simple example
Get current quarter of year.
SQL> select quarter (now ());
callret
INTEGER
_______________________________________________________________________________
4
See Also
dayname,
monthname,
dayofmonth,
dayofweek,
dayofyear,
week,
month,
year,
hour,
minute,
second,
timezone