This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I'm trying the DATEPART function to retrieve the day of the week eg: Monday, Tuesday etc...
I've used this query:
SELECT [Date],DATEPART(DW,[Date]) FROM [dbo].[RoadAccidents_2014]
The '[Date]' column is stored as a varchar(50),null string and is in the date format below:
09/01/2014
20/01/2014
21/01/2014
15/01/2014
09/01/2014
17/01/2014
10/01/2014
Processes in Microsoft 365 for setting up Office apps, redeeming product keys, and activating licenses.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
In addition SQL Server is returning the error message:'
Conversion failed when converting date and/or time from character string'