Select from following answers:- mm
- m
- n

- mcs
- All Above
DATENAME ( datepart , date ) function returns a character string that represents the specified datepart of the specified date.
Datepart abbreviations are as follows:
DatePart abbreviations
mm Month
m Month
n MINUTE
mcs Microseconds
--Script
SELECT DATENAME ( n, GETDATE()) MinuteValue
SELECT DATENAME ( mm, GETDATE()) MonthName
SELECT DATENAME ( m, GETDATE()) MonthName
SELECT DATENAME ( mcs, GETDATE()) MicroSeconds
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator