Name
quarter — get number of quarter of year from a datetime
Synopsis
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
Example24.249.Simple example
Get current quarter of year.
SQL> select quarter (now ()); callret INTEGER _______________________________________________________________________________ 4