Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

I want to extract the Actual day, for example Fri for 22/07/2016, from a DateTime field in SQL

Posted on 2016-07-22
5
Medium Priority
?
31 Views
Last Modified: 2016-10-01
I have tried CONVERT and looked at Date and Time Styles in SQL but I cannot see any that will output "DDD" as you can in Excel.


SELECT     call_date AS DateRaised, CONVERT(VARCHAR(30), call_date, 106) AS 'Day',
calltype, CallOutNo,
FROM         dbo.vw_CallsInByDay_01
WHERE     (DATEPART(YEAR, call_date)) = 2016
0
Comment
Question by:CMChalcraft
  • 3
5 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 41724441
Select datename(dw, getdate())
0
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 2000 total points
ID: 41724444
If you just wwant the short name, you can return the left 3 chars:

select left(datename(dw, getdate()), 3)

Open in new window

0
 

Author Comment

by:CMChalcraft
ID: 41724473
Very good. Thanks for the speedy response.

Regards

Chris C
0
 
LVL 25

Expert Comment

by:Lee Savidge
ID: 41739157
Hopefully it helped?

Thanks.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question