Which of the following query will give the DAY of today? (if today is Sunday menas Sunday should come)

 Posted by Nagasundar_Tn on 12/4/2012 | Category: Sql Server Interview questions | Views: 8380 | Points: 40
Select from following answers:
  1. SELECT CURRENTDAY = DATEPART(D,GETDATE())
  2. SELECT CURRENTDAY = DATENAME(dw,GETDATE())
  3. SELECT CURRENTDAY = DATEPART(dw,GETDATE())
  4. SELECT CURRENTDAY = DATENAME(D,GETDATE())
  5. All Above

Show Correct Answer


Asked In: GAVS Technology | Alert Moderator 

Comments or Responses

Login to post response