Time fields are grouped by month

Do report encountered a problem, according to the Date field to query the monthly statistics of a month, make a little time to get out, paste out to share.

Statements in 1,oracle grouped by month

<span style= "FONT-SIZE:18PX;" >		SELECT
			to_number (To_char (t.birth_date, ' mm ')) GetMonth,
		  COUNT (t.uuid) Total
		from
			t_ Person T

		GROUP
			by To_char (t.birth_date, ' mm ') ORDER by getmonth</span>

The query results are as follows:

Monthly query statements in 2,mysql

Select Month (createtime) newmonth,count (UUID) total from T_user Group by month (Createtime)

The query results are as follows:

The month method is not supported in Oracle and supports TO_CHAR (). Converts a date field to a month format. The same is true for years, weeks, and quarterly groupings.