This article will show you in detail how to use the DATENAME () datetime processing function in SQL Server with specific syntax and examples to better visualize and capture functions.
Describe
The DATENAME function in SQL Server returns a time value of the input argument, which can be day, month, year, quarter, hour, minute, second, millisecond . The return value is a string type (ASCII)
Syntax
To use the DATENAME function in SQL Server, we use the following syntax:
DATENAME(dangthoigian, thoigian)
Parameters :
Value Explanation year, yyyy, yy Yearquarter, qq, qQuýmonth, mm, mThdaydayofyearDate in daysday, dy, yYdayweek, ww, wkTuwwdayday, dw, w Day of the day, hhGinminute, mi, nPhútsecond, ss, s Millisecond, msMis second
Note :
For example
Take a look and explore some examples of DATENAME functions in SQL Server.
SELECT DATENAME(year, '2019/04/28');
Result: '2019'
SELECT DATENAME(yyyy, '2019/04/28');
Result: '2019'
SELECT DATENAME(yy, '2019/04/28');
Result: '2019'
SELECT DATENAME(month, '2019/04/28');
Result: 'April'
SELECT DATENAME(day, '2019/04/28');
Result: '28'
SELECT DATENAME(quarter, '2019/04/28');
Result: '2'
SELECT DATENAME(hour, '2019/04/28 09:49');
Result: '9'
SELECT DATENAME(minute, '2019/04/28 09:49');
Result: '49'
SELECT DATENAME(second, '2019/04/28 09:49:12');
Result: '12'
SELECT DATENAME(millisecond, '2019/04/28 09:49:12.726');
Result: '726'
Previous article: DATENAME function in SQL Server
Next article: DATEPART function in SQL Server
ncG1vNJzZmismaXArq3KnmWcp51ksaLAxKeYpp1dm8Kvr9OipqdlmaN6tL3LZqqeqqaavw%3D%3D