Using SQL Server 2005 Table1 <pre class="prettyprint"><code>Date 19-12-2009 20-12-2010 ..... </code></pre> Date Column datatype is <code>DATETIME</code>. Expected Output <pre class="prettyprint"><code>Monday Tuesday </code></pre> How to make a query for getting the day...

You can use the <code>DATENAME</code> function. <pre class="prettyprint"><code>SELECT DATENAME(WEEKDAY,[Date]) FROM Table1 </code></pre>

How to display a day from the Date

Using SQL Server 2005

Table1

Date

19-12-2009
20-12-2010
.....

Date Column datatype is DATETIME.

Expected Output

Monday
Tuesday

How to make a query for getting the day...

959

asked Dec 20 '10 18:12

You can use the DATENAME function.

SELECT DATENAME(WEEKDAY,[Date])
FROM Table1

answered Oct 05 '22 04:10

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!