How to get Current time only in Sql-Server?

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

Answer:

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

For Example:-

Select CONVERT(VARCHAR(11),GETDATE(),108);

Here,108 is the Time format as HH:mm:ss

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : How to get Current Date only in dd-MM-yyyy format ...

Next > : How to check whether Connection is Open or not?

More Interview Questions by vishalneeraj-24503

Latest Interview Questions