SELECT row by DATEPART()
SELECT * FROM my_table WHERE MONTH(date_column)=11
There is no DATEPART
function in MySQL. Use MONTH(date_column)
or EXTRACT(MONTH FROM date_column)
instead.
SELECT * FROM my_table WHERE MONTH(date_column)=11
There is no DATEPART
function in MySQL. Use MONTH(date_column)
or EXTRACT(MONTH FROM date_column)
instead.