How to get Current Date only in dd-MM-yyyy format in Sql-Server?

 Posted by vishalneeraj-24503 on 12/20/2013 | Category: Sql Server Interview questions | Views: 854 | Points: 40
Answer:

We can cast Gettime() function to such format,which shows only Current Date

For Example:-
Select CONVERT(VARCHAR(11),GETDATE(),105);


Here,105 is the Date format as dd-MM-yyyy means 20-12-2013


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response