SQL Server convert type and time format

Access statement
Select
Format (day, 'yyyy-mm-dd'), count (day)
From eqcon
Where
AAC = '000000' and datediff ('D', day, '2017-3-1 ') <= 0 and datediff ('D', day, '2017-3-31')> = 0

Group by format (day, 'yyyy-mm-dd ')

Sqlserver:
Select
Convert (nvarchar (10), day, 23), count (*), max (elevelsize)
From eqcon
Where
AAC = '20140901' and datediff (D, day, '2017-3-1 ') <= 0 and datediff (D, day, '2017-3-31')> = 0
Group by convert (nvarchar (10), day, 23)

================
Select
Datepart (D, day) as D, count (*) as C, max (elevelsize) as E
From eqcon
Where
AAC = '20140901' and datediff (D, day, '2017-3-1 ') <= 0 and datediff (D, day, '2017-3-31')> = 0
Group by datepart (D, Day)

A very powerful date Formatting Function in SQL Server

Select convert (varchar (100), getdate (), 0): 05 16 200610: 57am
Select convert (varchar (100), getdate (), 1): 05/16/06
Select convert (varchar (100), getdate (), 2): 06.05.16
Select convert (varchar (100), getdate (), 3): 16/05/06
Select convert (varchar (100), getdate (), 4): 16.05.06
Select convert (varchar (100), getdate (), 5): 16-05-06
Select convert (varchar (100), getdate (), 6): 16 05 06
Select convert (varchar (100), getdate (), 7): 05 16, 06
Select convert (varchar (100), getdate (), 8): 10:57:46
Select convert (varchar (100), getdate (), 9): 05 16 200610: 57: 46: 827am
Select convert (varchar (100), getdate (), 10): 05-16-06
Select convert (varchar (100), getdate (), 11): 06/05/16
Select convert (varchar (100), getdate (), 12): 060516
Select convert (varchar (100), getdate (), 13): 16 05 200610: 57: 46: 937
Select convert (varchar (100), getdate (), 14): 10: 57: 46: 967
Select convert (varchar (100), getdate (), 20): 2006-05-1610: 57: 47
Select convert (varchar (100), getdate (), 21): 2006-05-1610: 57: 47.157
Select convert (varchar (100), getdate (), 22): 05/16/06 10:57:47 AM
Select convert (varchar (100), getdate (), 23 ):
Select convert (varchar (100), getdate (), 24): 10:57:47
Select convert (varchar (100), getdate (), 25): 2006-05-1610: 57: 47.250
Select convert (varchar (100), getdate (), 100): 05 16 200610: 57am
Select convert (varchar (100), getdate (), 101): 05/16/2006
Select convert (varchar (100), getdate (), 102): 2006.05.16
Select convert (varchar (100), getdate (), 103): 16/05/2006
Select convert (varchar (100), getdate (), 104): 16.05.2006
Select convert (varchar (100), getdate (), 105): 16-05-2006
Select convert (varchar (100), getdate (), 106): 16 05 2006
Select convert (varchar (100), getdate (), 107): 05 16,200 6
Select convert (varchar (100), getdate (), 108): 10:57:49
Select convert (varchar (100), getdate (), 109): 05 16 200610: 57: 49: 437am
Select convert (varchar (100), getdate (), 110): 05-16-2006
Select convert (varchar (100), getdate (), 111): 2006/05/16
Select convert (varchar (100), getdate (), 112): 20060516
Select convert (varchar (100), getdate (), 113): 16 05 200610: 57: 49: 513
Select convert (varchar (100), getdate (), 114): 10: 57: 49: 547
Select convert (varchar (100), getdate (), 120): 2006-05-1610: 57: 49
Select convert (varchar (100), getdate (), 121): 2006-05-1610: 57: 49.700
Select convert (varchar (100), getdate (), 126): 2006-05-16t10: 57: 49.827
Select convert (varchar (100), getdate (), 130): 18 ???? ?????? 142710: 57: 49: 907am
Select convert (varchar (100), getdate (), 131): 18/04/142710: 57: 49: 920am