Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.
Solved
Converting Dates with SQL
Posted on 2013-01-07
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6 Comments
CAST / CONVERT in BOL should cover this..
http://msdn.microsoft.com/en-us/library/ms187928%28v=sql.105%29.aspx
HTH,
Kent
http://msdn.microsoft.com/en-us/library/ms187928%28v=sql.105%29.aspx
HTH,
Kent
Active today
Cast/Convert don't seem to translate the date format into words.
You need the DATENAME function to do that.
Here's a (somewhat ugly) way to handle it but shows how to extract the words from a datetime parameter:
DATEPART: http://msdn.microsoft.com/en-us/library/ms174420.aspx
DATENAME: http://msdn.microsoft.com/en-us/library/ms174395.aspx
You need the DATENAME function to do that.
Here's a (somewhat ugly) way to handle it but shows how to extract the words from a datetime parameter:
select datename(dw,getdate())+', '+
datename(mm,getdate())+' '+
rtrim(convert(char,datepart(dd,getdate())))+', '+
rtrim(convert(char,datepart(yyyy, getdate())))
Monday, January 7, 2013
DATEPART: http://msdn.microsoft.com/en-us/library/ms174420.aspx
DATENAME: http://msdn.microsoft.com/en-us/library/ms174395.aspx
Active today
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.
Featured Post
This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder. The folder can be on the local hard drive or on a network share. This batch file will query the SQL server to get the current date & time and wi…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB.
To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month13 days, 22 hours left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.