### Update for SQL Server 2012+

I always find the `CONVERT` magic numbers hard to remember.  You can use [`FORMAT`][1] instead and provide a formatting pattern string like this:


```sql
SELECT FORMAT(GetDate(),'yyyy-MM')
```

**See Also**: [Convert date to YYYYMM format][2]

[1]: https://learn.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql
[2]: https://stackoverflow.com/a/49890439/1366033

need the date in the format yyyy-mm and should be grouped to get 
the count but when i give the 

    group by date is says invalid

i have found this solution 

can anyone help me by providing other solution


    select 
    count(*) as count, 
    Convert(char(10), RH.updated_datetime, 105) as date,
    SUM( 
      datediff(SECOND, 
           PRI.procedure_performed_datetime ,RH.updated_datetime
      )
    )/count(*) as average_reporting_tat 
    from 
    report R, 
    report_history RH, 
    study S, 
    procedure_runtime_information PRI, 
    priorities PP, 
    patient P, 
    "procedure" PR 
    
    where 
    
    RH.report_fk=R.pk and RH.pk IN ( 
      select pk from ( 
        select * from report_history where report_fk=r.pk  
      ) as result 
      where old_status_fk IN (21, 27)
    ) AND R.study_fk = S.pk 
    AND S.procedure_runtime_fk = PRI.pk 
    AND PRI.procedure_fk = PR.pk 
    AND S.priority_fk = PP.pk 
    AND PRI.patient_fk = P.pk 
    AND RH.updated_datetime >= '2012-05-01' 
    AND RH.updated_datetime <= '2013-09-12' 
    group by Convert(char(10), RH.updated_datetime, 105)



need date in the format yyyy-mm in mssql

*As of SQL Server 2012+*, you can use [<code>FORMAT(<i>value, format [, culture ]</i>)</code>][1]

Where the `format` param takes any valid [standard format string][2] or [custom formatting string][3]

**Example**:

```sql
SELECT FORMAT(GETDATE(), 'dd-MMM-yyyy')
```

**Further Reading**: 

* [How to convert DateTime to VarChar][4]
* [How to convert date to a format `mm/dd/yyyy`][5]
* [sql server convert date to string MM/DD/YYYY][6]

[1]: https://learn.microsoft.com/en-us/sql/t-sql/functions/format-transact-sql
[2]: https://learn.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings
[3]: https://learn.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings

[4]: https://stackoverflow.com/q/74385/1366033
[5]: https://stackoverflow.com/q/18568410/1366033
[6]: https://stackoverflow.com/q/11854775/1366033

I'm using following line of code in SQL:

    REPLACE(CONVERT(VARCHAR(11),getdate(),106), ' ','-') 

to convert given date to `MMM-DD-YYYY` format, this code is working perfectly fine if current date is more that 10th. 

But I'm getting error when its tries to convert single digit date, e.g when I'm converting date `9 jan 2014`. It is converted to `Jan--9-2014`.

Which is actually wrong as its contain one extra ` - `. 

Please help me to resolve this issue.