Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to display a day from the Date

Tags:

sql

sql-server

tsql

sql-server-2005

date-formatting

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...

like image 959
Gopal Avatar asked Dec 20 '10 18:12

Gopal

1 Answers

You can use the DATENAME function.

SELECT DATENAME(WEEKDAY,[Date])
FROM Table1
like image 66
Lamak Avatar answered Oct 05 '22 04:10

Lamak
Sign in to Comment

Related questions

Invalid Object Name Error in Function in SQL
Adding an aggregate function to the WHERE clause? [duplicate]
Python MariaDB pip install failed, missing mariadb_config
How do I calculate the last day of the month in SQL?
Stored Procedures to .sql files
Converting the name of a day to its integer representation
Most efficient way to select 1st and last element, SQLite?
List all the months using oracle sql
SQL Select Certain Value First
Difference between WHERE and HAVING in SQL [duplicate]
Median values in T-SQL
SQL Server 2005 DateTime (return only hh:mm)
"LIMIT 5,10" returns 9 rows in MySQL?
Different value counts on same column
Calling SQL select statement from C# thousands of times and is very time consuming. Is there a better way?
difference between 'natural full outer join' and 'full outer join' [closed]
How to Set a Value to NULL when using Zend_Db
Is this stored procedure thread-safe? (or whatever the equiv is on SQL Server)
Select `n` last inserted records in table - oracle
Database "key/ID" design ideas, Surrogate Key, Primary Key, etc

Donate For Us

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