I want to use a SQL query using SQL Server 2005 and 2008 to get simply the Time from the DateTime column. Default output:
AttDate
==
2011-02-09 13:09:00
2011-02-09 14:10:00
I want to have this output:
AttDate Time
==
2011-02-09 13:09:00 13:09
2011-02-09 14:10:00 14:10
Can someone please help me with this?