How to get Time from given date?

Posted by Rajesh_Kumar on 2/18/2014 | Category: Sql Server Interview questions | Views: 1983 | 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

Bookmark It

< Previous : How to perform Event handling in silver light?

Next > : How to get Date part from given date or current da ...

More Interview Questions by Rajesh_Kumar

Latest Interview Questions