How to extract time from string?

[madsstiig]

Hi.
I'm working on a report that uses a DB with a time field (called DOSR_STUDY.STUDY_TIME) that is actually a string (e.g. 101904.812000 is 10:19 a.m. and some seconds and milliseconds).
How do i extract that into an understandable time format like just 10:19?

 

[appnair]

not sure whay you are posting it in the LL forum,Anyways all databases have utility functions for this.Try googling for
"sqlserver date time"

Well, if I called the wrong number, why did you answer the phone?
James Thurber, New Yorker cartoon caption, June 5, 1937
Certified OT Developer and probably certfiable,Livelink ECM Champion 2008

http://www.linkedin.com/in/appunair