Clauses EXTRACT
La clause
EXTRACT
extrait un composant Date/Heure d’une colonne de type DateTime.Exemples
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"
Fournir une réponse