Example and Notes
Use this SQL Server example as a starting point for development, troubleshooting, reporting, or maintenance work. Review it against your schema, data volume, permissions, and SQL Server version before using it in production.
The DateName function is a powerful SQL function you can use to manipulate and work with dates and return an text value based on the part of the date you select. For example, you may want to get the name of the day or month in a specific date. The example scripts below will show you how to get specific values for a date.
Examples of Using the DateName Function
DECLARE @Date datetime2 = '2018-09-25 19:47:00.8631597'
|
| Unit of time |
Abbreviations |
Query |
Result |
| WEEKDAY |
dw |
SELECT DATENAME(WEEKDAY,@Date) |
Sunday
|
| MONTH |
mm, m |
SELECT DATENAME(MM,@Date) |
September |
Production Review
WSI can adapt this script for your database, improve error handling, tune performance, document the logic, and help deploy it safely.