*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(), 'MM/dd/yyyy')
```

**Further Reading**: 

* [How to convert DateTime to VarChar][4]
* [How to convert date to a format `mm/dd/yyyy`][5]

[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


I am using SQL Server 2008.

I have the following:

        select convert(varchar(20),fmdate) from Sery

How do I convert the date to string such that it show as MM/DD/YYYY

sql server convert date to string MM/DD/YYYY

Answer