Which of the following statements will return a different value?

 Posted by Bandi on 6/30/2015 | Category: Sql Server Interview questions | Views: 658 | Points: 40
Select from following answers:
  1. SELECT YEAR(GETDATE())
  2. SELECT DATEPART(Y, GETDATE())
  3. SELECT LEFT(CONVERT(VARCHAR(10), GETDATE(), 111), 4)
  4. SELECT CONVERT(VARCHAR(4), GETDATE(), 120)
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response