How to get Time from given date?

 Posted by Rajesh_Kumar on 2/18/2014 | Category: Sql Server Interview questions | Views: 541 | Points: 40
Answer:

Select Convert(Varchar(8),Getdate(),108) as time_only;


108 is a format provided by dot net for extracting time part from given date in sql server.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response