EXTRACT() function to get from MySQL

SELECT EXTRACT(YEAR FROM '2017-03-08');

Output is 2017

Input format must be in "YYYY-MM-DD HH-MM-SS" , we can use STR_TO_DATE() for any other format ( See examples below )

SELECT EXTRACT( DAY FROM  '2017-04-28' );

Output 28

SELECT EXTRACT( DAY FROM  '2017-04-28' );

Output 28

SELECT EXTRACT( MONTH FROM  '2017-10-10' );

Output is 10

SELECT EXTRACT( YEAR_MONTH FROM  '2017-03-08' )

Output is 201703

EXTRACT() with STR_TO_DATE()

We can use other type input date formats also.

SELECT EXTRACT( YEAR FROM STR_TO_DATE('5-07-2017', '%d-%m-%Y') )

SELECT EXTRACT( YEAR FROM NOW() )

Output is Present Year 2017

SELECT EXTRACT( HOUR FROM NOW( ) )

Output is 11

SELECT EXTRACT( MINUTE FROM NOW( ) )

Output is 40

SELECT EXTRACT( SECOND FROM NOW( ) )

Output is 32

SELECT EXTRACT( MICROSECOND FROM '2017-02-11 22:39:59.000020' )

Output is 20

SELECT EXTRACT( HOUR_MINUTE FROM NOW( ) )

Output is 1140

SELECT EXTRACT( MINUTE_SECOND FROM NOW( ) )

Output is 4032

SELECT EXTRACT( SECOND_MICROSECOND FROM '2017-02-11 22:39:59.000020' ) //Output 59000020

SELECT EXTRACT( YEAR FROM localtimestamp() )

SELECT EXTRACT( MONTH FROM localtimestamp() )

SELECT EXTRACT( HOUR_MINUTE FROM localtimestamp() )

SELECT EXTRACT( DAY FROM CURDATE() )

Output is 21

SELECT EXTRACT( MONTH FROM CURDATE() )

Output is 05

SELECT EXTRACT( YEAR FROM CURDATE() )