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 & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author   Watch on YouTube

Connect: