exemple requete mysql avec MONTH SELECT count(id),month(mydate) FROM mydb.mytable WHERE id= 3 Group by month(mydate) Equivalent Oracle : SELECT count(id) , to_char(mydate, 'M') FROM mydb.mytable WHERE id=3 GROUP BY to_char(mydate,
exemple requete mysql avec MONTH SELECT count(id),month(mydate) FROM mydb.mytable WHERE id= 3 Group by month(mydate) Equivalent Oracle : SELECT count(id) , to_char(mydate, 'M') FROM mydb.mytable WHERE id=3 GROUP BY to_char(mydate,