How to get Time from DateTime format in SQL?

sql-server tsql sql-server-2005 datetime

SQL Server 2008:

SELECT cast(AttDate as time) [time]FROM yourtable

Earlier versions:

SELECT convert(char(5), AttDate, 108) [time]FROM yourtable

sql-server tsql sql-server-2005 datetime

Assuming Sql server

SELECT CONVERT(VARCHAR(8),GETDATE(),108)

sql-server tsql sql-server-2005 datetime

SQL Server 2008+ has a "time" datatype

SELECT     ..., CAST(MyDateTimeCol AS time)FROM   ...

For older versions, without varchar conversions

SELECT     ..., DATEADD(dd, DATEDIFF(dd, MyDateTimeCol, 0), MyDateTimeCol)FROM   ...

CodeHunter