MySQL Date and Time Exercises: Query to get the firstname, lastname who joined in the month of June

MySQL Date Time: Exercise-15 with Solution

Write a query to get the firstname, lastname who joined in the month of June.

Sample table: employees

Code:

SELECT first_name, last_name 
    FROM employees WHERE MONTH(HIRE_DATE) =  6;

Sample Output:

first_name		last_name
Steven		King
Neena		Kochhar
Lex	De 	Haan
Alexander	Hunold
Bruce		Ernst
David		Austin
Valli		Pataballa
Diana		Lorentz
Nancy		Greenberg
Daniel		Faviet
John		Chen
Ismael		Sciarra
Jose Manuel	Urman
Luis		Popp

Pictorial Presentation of the above query:

MySQL Code Editor:

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous:Write a query to display the current date in the specified format.
Next:Write a query to get the years in which more than 10 employees joined.