SELECT DATENAME(dw,GETDATE()) -- Friday
SELECT DATEPART(dw,GETDATE()) -- 6
More Related Contents:
- Convert text to system date format [duplicate]
- How to return only the Date from a SQL Server DateTime datatype
- Best approach to remove time part of datetime in SQL Server
- DateTime2 vs DateTime in SQL Server
- SQL query to select dates between two dates
- How to combine date from one field with time from another field – MS SQL Server
- How can I select the first day of a month in SQL?
- How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
- How to convert DateTime to VarChar
- T-SQL: Round to nearest 15 minute interval
- SQL Server Convert Varchar to Datetime
- How Can I use “Date” Datatype in sql server?
- How to determine the number of days in a month in SQL Server?
- Calculate business hours between two dates
- SQL Server convert string to datetime
- How do I query for all dates greater than a certain date in SQL Server?
- A way to extract from a DateTime value data without seconds
- How can I compare time in SQL Server?
- Difference of two date time in sql server
- Custom Date/Time formatting in SQL Server
- How to compare datetime with only date in SQL Server
- Getting Dates between a range of dates
- How can I convert a Sql Server 2008 DateTimeOffset to a DateTime
- What is the internal representation of datetime in sql server?
- SQL SERVER DATETIME FORMAT
- SQL JOIN vs IN performance?
- Can a foreign key be NULL and/or duplicate?
- SQL SERVER: Get total days between two dates
- Create parameterized VIEW in SQL Server 2008
- What is the most appropriate data type for storing an IP address in SQL server? [duplicate]