Microsoft SQL Sample Code
DateName Function
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 |
If you need any help implementing this
function or modifications made for your needs, please
Click Here to get a free
quote for your Microsoft
SQL Development needs.
Click Here to learn more
about the WSI quoting
process.