sql server convert date to string MM DD YYYY

Question

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

User · Answer

select convert varchar 10   cast fmdate as date   101  from sery   Without cast I was not getting fmdate converted  so fmdate was a string

User · Answer

select convert varchar 10   fmdate  101  from sery   101 is a style argument   Rest of  em can be found here   T-SQL Cast   Convert date to string

User · Answer

That task should be done by the next layer up in your software stack  SQL is a data repository  not a presentation system  You can do it with  CONVERT VARCHAR 10   fmdate    101    But you shouldn t

User · Answer

As of SQL Server 2012   you can use FORMAT value  format    culture     Where the format param takes any valid standard format string or custom formatting string  Example   SELECT FORMAT GETDATE     MM dd yyyy     Further Reading     How to convert DateTime to VarChar How to convert date to a format mm dd yyyy

User · Answer

See this article on SQL Server Helper - SQL Server 2008 Date Format

[sql-server-2008-r2] sql server convert date to string MM/DD/YYYY

Examples related to sql-server-2008-r2