EXTRACT() : Parts of Date & Time in MySQL

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

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

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

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

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

EXTRACT() with STR_TO_DATE()

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

Read more on STR_TO_DATE()

EXTRACT() with NOW()

SELECT EXTRACT( YEAR FROM NOW() )

SELECT EXTRACT( HOUR FROM NOW( ) )

SELECT EXTRACT( MINUTE FROM NOW( ) )

SELECT EXTRACT( SECOND FROM NOW( ) )

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

SELECT EXTRACT( HOUR_MINUTE FROM NOW( ) )

SELECT EXTRACT( MINUTE_SECOND FROM NOW( ) )

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

Read more on NOW()

EXTRACT() with LOCALTIMESTAMP()

SELECT EXTRACT( YEAR FROM localtimestamp() )

SELECT EXTRACT( MONTH FROM localtimestamp() )

SELECT EXTRACT( HOUR_MINUTE FROM localtimestamp() )

EXTRACT() with CURDATE()

SELECT EXTRACT( DAY FROM CURDATE() )

SELECT EXTRACT( MONTH FROM CURDATE() )

SELECT EXTRACT( YEAR FROM CURDATE() )

Subhendu Mohapatra

Author

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

← Subscribe to our YouTube Channel here