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: 2262 | 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

Bookmark It

< Previous : What happend when we have a method inside a Web se ...

Next > : How to get Current time only in Sql-Server?

More Interview Questions by vishalneeraj-24503

Latest Interview Questions