How to get Current time only in Sql-Server?

 Posted by vishalneeraj-24503 on 12/20/2013 | Category: Sql Server Interview questions | Views: 1807 | 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 

Comments or Responses

Login to post response