Get day of week in SQL Server 2005/2008
Posted By: aaaa
If I have a date 01/01/2009, I want to find out what day it was e.g. Monday, Tuesday, etc…
Is there a built-in function for this in SQL Server 2005/2008? Or do I need to use an auxiliary table?
Solution
SELECT DATENAME(dw,GETDATE()) -- Friday
SELECT DATEPART(dw,GETDATE()) -- 6
Answered By: Anonymous
Related Articles
- Javascript and css animation
- Apache server keeps crashing, "caught SIGTERM,…
- Get week day name from a given month, day and year…
- Get a list of dates between two dates
- Get the correct week number of a given date
- How to add a unique id to an array in one loop…
- How to get min max day in a week every month?
- case statement in where clause - SQL Server
- Get first day of week in SQL Server
- Obtain most recent value for based on index in a…
- Java string to date conversion
- Current time formatting with Javascript
- Nested ng-repeat
- How to get week number of the month from the date in…
- How to generate JAXB classes from XSD?
- How to calculate age (in years) based on Date of…
- Get week of year in JavaScript like in PHP
- Vue.js toggle button based on the result of two…
- Sort table rows In Bootstrap
- Sort days of the week depending on time slots
- Get the week start date and week end date from week number
- Rails Active Record find(:all, :order => ) issue
- Modulus operator c# example
- How to manage nested arrays in Vuex Store and pass…
- Sort a two dimensional array based on one column
- How do I insert multiple checkbox values into a table?
- Converting year and month ("yyyy-mm" format) to a date?
- Calculate the number of business days between two dates?
- Calendar Recurring/Repeating Events - Best Storage Method
- Get current time in hours and minutes
- Is it possible to style different sections of…
- Mysql Compare two datetime fields
- DataTable draw daterange from vaadin-date-picker in polymer
- python 3.2 UnicodeEncodeError: 'charmap' codec can't…
- How to convert java.util.Date to java.sql.Date?
- Custom date picker in Vuetify
- Calculate date from week number
- MS SQL Date Only Without Time
- How do I exclude Weekend days in a SQL Server query?
- Get dates from a week number in T-SQL
- Convert Rows to columns using 'Pivot' in SQL Server
- Getting the difference between two Dates…
- Check if a string is a valid date using DateTime.TryParse
- How to get the day of week and the month of the year?
- Polymer: iron-selector issue
- Efficiency of Java "Double Brace Initialization"?
- Changing the value of a column in a dataframe
- What is the difference between `Enum.name()` and…
- Starting the week on Monday with isoWeekday()
- Python: How to find a day week given the starting…
- Android: how to get the current day of the week…
- how to return JSON object if search string matches…
- D3 chart integration into Vuejs
- Calculating number of full months between two dates in SQL
- Check if a given moment lies in same week than at…
- How to return only the Date from a SQL Server…
- Access Vue from external files
- Subtracting Dates in Oracle - Number or Interval Datatype?
- Get last sunday of month - python
- Declare a variable which converts Date data type to Integer
- data.table vs dplyr: can one do something well the…
- Javascript, Time and Date: Getting the current…
- How to get first and last day of the current week in…
- T-SQL stored procedure that accepts multiple Id values
- How to obtain the start time and end time of a day?
- Convert Java Date to UTC String
- Calculate business days
- SQL Server datetime LIKE select?
- Print text instead of value from C enum
- SMTP error 554
- How do I get just the date when using MSSQL GetDate()?
- sql server Get the FULL month name from a date
- What are the date formats available in…
- How to compare two dates to find time difference in…
- pandas read_csv and filter columns with usecols
- How to use enums in C++
- Specific Time Range Query in SQL Server
- How do I make a burn down chart in Excel?
- Enumerations on PHP
- How do I convert a calendar week into a date in Excel?
- Count work days between two dates
- SimpleDateFormat("EEEE") Returns Wrong Day of Week…
- How to group time by hour or by 10 minutes
- Binding an ember model's date attribute to…
- First week of year considering the first day last year
- Pandas left outer join multiple dataframes on…
- How to convert a full date to a short date in javascript?
- Aurelia - Using variable as name of property in data binding
- How do I loop through a date range?
- Is this request generated by EF Core buggy or is it my code?
- Failed linking file resources
- JavaScript - get the first day of the week from current date
- Calculate time difference in minutes in SQL Server
- How to print a date in a regular format?
- Blocks and yields in Ruby
- Find the day of a week
- How can I set hours and minutes of date with oracle sql?
- The number of method references in a .dex file…
- How To Edit Date and Time Picker Vuejs Vuetify From…
- Crontab Day of the Week syntax
Disclaimer: This content is shared under creative common license cc-by-sa 3.0. It is generated from StackExchange Website Network.
