Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Course Of The Month
2 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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 5 days ago
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
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
Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Suggested Courses
Course of the Month2 days, 9 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.