Saturday, 03 June 2017 07:29

How to Select Record in Mysql Using Month and Year

Select Record in MySql that Matches Month and Year
Example
SELECT * FROM tb_procedure WHERE MONTH(code_date) = 6 AND YEAR(code_date) = 2017;

The SQL Syntax above will select record whose Month is June and Year is 2017.

 

Result
Month and Year Select MySql

 

Last modified on Saturday, 03 June 2017 08:33

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.