Jahr aus Datum extrahieren

ID230
Link ReferenceNot set
Link CreditsNot set
Link Technical DocumentationNot set
PlCodelangMySQL
PlGroupDatum, Zeit
PlItemTitleJahr aus Datum extrahieren
CodeSELECT extract(year from now()) AS Year;
SELECT extract(year from '2014-01-01') AS Year;
-- 2014
Result Example