Select from following answers:- SELECT CURRENTDAY = DATEPART(D,GETDATE())
- SELECT CURRENTDAY = DATENAME(dw,GETDATE())

- SELECT CURRENTDAY = DATEPART(dw,GETDATE())
- SELECT CURRENTDAY = DATENAME(D,GETDATE())
- All Above
Here DateName function we should use. DateName functions always returns varchar where as DatePart function returns integer.
Both DatePart function (DATEPART(D,GETDATE()) and DATEPART(dw,GETDATE())) returns integer values. DATENAME(D,GETDATE()) returns current number of the day with respect to week in varchar format.
Show Correct Answer
Asked In: GAVS Technology |
Alert Moderator