DATEPART
DATEPART(YEAR, d) | ||
---|---|---|
Engine | OK | Alternative |
ingres | No | EXTRACT(YEAR FROM d) |
mysql | No | EXTRACT(YEAR FROM d) |
oracle | No | EXTRACT(YEAR FROM d) |
postgres | No | EXTRACT(YEAR FROM d) |
sqlserver | Yes | DATEPART(YEAR, d) |
DATEPART
DATEPART allows you to retrieve components of a date.
You can extract also YEAR, MONTH, DAY, HOUR, MINUTE, SECOND.
DATEPART(YEAR, d) DATEPART(MONTH, d) DATEPART(DAY, d) DATEPART(HOUR, d) DATEPART(MINUTE, d) DATEPART(SECOND, d)
schema:gisq
In this example you get the year and the month from the date whn
.
SELECT whn
,DATEPART(YEAR, whn) AS yr
,DATEPART(MONTH, whn) AS mnth
FROM eclipse
SELECT whn
,EXTRACT(YEAR FROM td) AS yr
,EXTRACT(MONTH FROM td) AS mnth
FROM gisq.eclipse
SELECT whn
,EXTRACT(YEAR FROM td) AS yr
,EXTRACT(MONTH FROM td) AS mnth
FROM eclipse
See also
Language: | English • Deutsch |
---|