Difference between revisions of "HOUR"
From SQLZOO
| Line 34: | Line 34: | ||
,whn | ,whn | ||
,wht | ,wht | ||
| − | FROM eclipse | + | FROM gisq.eclipse |
</source> | </source> | ||
<source lang='sql' class='def'> | <source lang='sql' class='def'> | ||
Revision as of 15:58, 16 July 2012
| HOUR(d) | ||
|---|---|---|
| Engine | OK | Alternative |
| ingres | No | EXTRACT(HOUR from d) |
| mysql | Yes | EXTRACT(HOUR from d) |
| oracle | No | TO_CHAR(d,'HH24') |
| postgres | No | EXTRACT(HOUR from d) |
| sqlserver | Yes | DATEPART(HOUR,d) |
HOUR
HOUR allows you to retrieve the hour from a datetime.
HOUR(d)
In this example you get the hour from the datetime field whn.
SELECT EXTRACT(HOUR FROM whn) AS v ,whn ,wht FROM eclipse
SELECT EXTRACT(HOUR FROM whn) AS v ,whn ,wht FROM eclipse
SELECT TO_CHAR(whn,'HOUR') AS v ,whn ,wht FROM gisq.eclipse
SELECT HOUR(whn) AS v, whn, wht FROM eclipse
See also
