EXTRACT
Clausole

La
EXTRACT
clausola estrae un componente Data/Ora da una
DateTime
colonna tipo.

Esempi

SELECT EXTRACT(DAY FROM Time) AS "Day" FROM ...
SELECT EXTRACT(YEAR FROM Time) AS "Year" FROM ...
SELECT EXTRACT(MONTH FROM Time) AS "Month" FROM ...
SELECT EXTRACT(HOUR FROM Time) AS "Hour" FROM ...
SELECT EXTRACT(MINUTE FROM Time) AS "Minute" FROM ...
SELECT EXTRACT(SECOND FROM Time) AS "Second" FROM ...
Fornire un feedback
Hai domande o feedback su questa documentazione? invia il tuo feedback qui.