Microsoft Logo

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

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.

About Us

WSI is a small business and a leading provider of custom SQL Server/Azure programming and database solutions for government entities, Fortune 1000 companies, and emerging businesses. We are your custom SQL Server/Azure development experts.