EXTRACT-Klauseln
⟩
⟩
⟩
⟩
⟩ Extract clauses

EXTRACT-Klauseln

Die
EXTRACT
-Klausel extrahiert eine Date/Time-Komponente aus einer Spalte des Typs DateTime.

Beispiele

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"
Rückmeldung geben
Haben Sie Fragen oder Feedback zu dieser Dokumentation? Bitte geben Sie hier Ihr Feedback ab.
Normal