MySQL – extract()

Zwraca składnik z daty np. rok

  SELECT EXTRACT( MONTH FROM "2017-06-15" ); 

Składnia

  EXTRACT( unit FROM date )

Units – sładniki czasu

    MICROSECOND
    SECOND
    MINUTE
    HOUR
    DAY
    WEEK
    MONTH
    QUARTER
    YEAR
    SECOND_MICROSECOND
    MINUTE_MICROSECOND
    MINUTE_SECOND
    HOUR_MICROSECOND
    HOUR_SECOND
    HOUR_MINUTE
    DAY_MICROSECOND
    DAY_SECOND
    DAY_MINUTE
    DAY_HOUR
    YEAR_MONTH