Link to home
Start Free TrialLog in
Avatar of novice12
novice12

asked on

How to extract time from Datetime in MS T-SQL

Using MS SQL 7

I have a datetime field that looks like this : 2007-1-30 10:39:00. How can I extract the time only to get some thing like this:
10:39:00?

I other words, I want get rid of the date and keep the time only.

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3]
Flag of Luxembourg image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial