Jahr aus Datum extrahieren
ID | 230 |
---|---|
Link Reference | Not set |
Link Credits | Not set |
Link Technical Documentation | Not set |
PlCodelang | MySQL |
PlGroup | Datum, Zeit |
PlItemTitle | Jahr aus Datum extrahieren |
Code | SELECT extract(year from now()) AS Year; SELECT extract(year from '2014-01-01') AS Year; -- 2014 |
Result Example |