Clausole EXTRACT
⟩
⟩
⟩
⟩
⟩ Extract clauses

Clausole EXTRACT

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

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 ...
SELECT * FROM "DataLogger1" WHERE EXTRACT(YEAR FROM Timestamp) = "2025"
Fornire un feedback
Hai domande o feedback su questa documentazione? invia il tuo feedback qui.
Normal