T-SQL is counted by year, month, day according to date time

See Statistical results:

Here is the CONVERT function, and here we have to say the CONVERT function

The CONVERT () function is a general function that converts a date to a new data type.

The CONVERT () function can display date/time data in different formats.

Grammar

CONVERT (data_type (length),data_to_be_converted,style)

Data_type (length) The data type to be converted, you can specify the length of the data type, in this case by year, the specified conversion to a string type, length 4,

The field to convert, in this case the Createtime

style Specifies the date/time output format . Optional Fields

Format refer to the table below:

Detailed reference:
Http://www.w3school.com.cn/sql/func_convert.asp

T-SQL is counted by year, month, day according to date time