I want to get only Time from DateTime column using SQL query
using SQL Server 2005 and 2008
Default output:

AttDate                   
==
2011-02-09 13:09:00    
2011-02-09 14:10:00    

I’d like this output:

AttDate                Time 
==
2011-02-09 13:09:00    13:09
2011-02-09 14:10:00    14:10

18 Answers
18

Leave a Reply

Your email address will not be published. Required fields are marked *