Collections:
Getting Month and Weekday Names from DATATIME Values in SQL Server
How To Get Month and Weekday Names from DATETIME Values in SQL Server Transact-SQL?
✍: FYIcenter.com
In DATETIME values, the month part and weekday part have names. You can use the DATENAME() function to get the month name and weekday name from a DATETIME value in the following format:
DATENAME(datepart, date) returns NVARCHAR: "date" - the input date "datepart" - "month" or "weekday"
Here is a simple example:
DECLARE @submit_date DATETIME; SET @submit_date = '2007-05-19 16:10:41.403'; SELECT 'Posted in the month of ' + DATENAME(month, @submit_date) + ' on a '+DATENAME(weekday, @submit_date); GO Posted in the month of May on a Saturday
⇒ Getting Parts of DATETIME Values as Integers in SQL Server
⇐ Calculating Age in Days, Hours and Minutes in SQL Server
⇑ Date/Time Operations and Functions in SQL Server Transact-SQL
2017-02-14, 1476🔥, 0💬
Popular Posts:
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...