How to convert varchar to time? 2

[dgillz]

I have start and end times that are stored as varchar such as "0700", "1600", etc. How do I convert these to time?

Macola and Sage 50/Sage 100 Consultant

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[Chris Miller]

Using the STUFF function, for example

SELECT CAST(STUFF('0700',3,0,':') as time)

Chriss