QUARTER
From SQLZoo
| QUARTER(d) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | Yes | EXTRACT(QUARTER from d) |
| mysql | Yes | EXTRACT(QUARTER from d) |
| oracle | No | TO_CHAR(d,'Q') |
| postgres | No | EXTRACT(QUARTER from d) |
| sqlserver | No | DATEPART(QUARTER,d) |
QUARTER
QUARTER allows you to retrieve the 3 month period from a date.
| First Quarter | January 1 | March 31 |
| Second Quarter | April 1 | June 30 |
| Third Quarter | July 1 | September 30 |
| Fourth Quarter | October 1 | December 31 |
QUARTER(d)
In this example you get the quarter from the date field wk. Lately, Cliff Richard favours Q4.
SELECT wk,
EXTRACT(QUARTER from wk) AS Quarter,
song
FROM totp
WHERE singer = 'Cliff Richard'
ORDER BY wk DESC
SELECT wk,
TO_CHAR(wk,'QUARTER') AS Quarter,
song
FROM gisq.totp
WHERE singer = 'Cliff Richard'
ORDER BY wk DESC
SELECT wk,
DATEPART(QUARTER,wk) AS Quarter,
song
FROM totp
WHERE singer = 'Cliff Richard'
ORDER BY wk DESC
SELECT wk,
QUARTER(wk) AS Quarter,
song
FROM totp
WHERE singer = 'Cliff Richard'
ORDER BY wk DESC
See also
- EXTRACT function
- +(date) function
- HOUR function
- MINUTE function
- DAY function
- SECOND function
- MONTH function
| Language: | English • Deutsch |
|---|
