How to get Time from DateTime format in SQL?

by

SQL Server 2008:

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

Earlier versions:

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

More Related Contents:

  1. Sql Server string to date conversion
  2. Check if table exists in SQL Server
  3. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  4. SQL query to select dates between two dates
  5. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  6. Parameter Sniffing (or Spoofing) in SQL Server
  7. What is the significance of 1/1/1753 in SQL Server?
  8. SQL Server String or binary data would be truncated
  9. Datatype for storing ip address in SQL Server
  10. How to change identity column values programmatically?
  11. How much size “Null” value takes in SQL Server
  12. best way to convert and validate a date string
  13. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  14. Date conversion and culture: Difference between DATE and DATETIME
  15. SQL Server ORDER BY date and nulls last
  16. SQL Query to find the last day of the month
  17. How to remove accents and all chars a..z in sql-server?
  18. WHERE clause on SQL Server “Text” data type
  19. SQL Server error on update command – “A severe error occurred on the current command”
  20. Aggregate bitwise-OR in a subquery
  21. How can I get the sum of multiple datetime values?
  22. SQL server schema and default schema
  23. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  24. FOR XML PATH(”): Escaping “special” characters
  25. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  26. Does query plan optimizer works well with joined/filtered table-valued functions?
  27. What are row, page and table locks? And when they are acquired?
  28. Convert UTC Milliseconds to DATETIME in SQL server
  29. @@ERROR and/or TRY – CATCH
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment