asked on Converting Dates with SQL
I know I've done this before but can't remember
How do I convert a date so it comes out in long day, month year format in t-sql
for example
1/17/2013
to
Monday, January 7, 2013
How do I convert a date so it comes out in long day, month year format in t-sql
for example
1/17/2013
to
Monday, January 7, 2013
Microsoft SQL Server 2008
Last Comment
Anthony Perkins
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
select Format (sysdatetime(), 'D', 'en-US')
PatelAlpesh, the FORMAT function only exists in SQL Server 2012. The question clearly states that the asker uses SQL Server 2008. Please read the full question and other posts before deciding to post yourself. (this is not the first time)
The answer by sjwales achieves what has been asked.
The answer by sjwales achieves what has been asked.
this is not the first time
And unfortunately it will not be the last, despite repeated reminder over the years.
And unfortunately it will not be the last, despite repeated reminder over the years.
http://msdn.microsoft.com/en-us/library/ms187928%28v=sql.105%29.aspx
HTH,
Kent