Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by juniordba
-
Converting int to hh:mm:ss format
This solution worked: Select TimeValue = replace(stuff(stuff(str(IntColumn,6),5,0,':'),3,0,':'),' ','0') From YourTable But im also going to try the last one...will let you know how it goes.. once again, thanks for the help!- juniordba
- Post #12
- Forum: Microsoft SQL Server: Programming
-
Converting int to hh:mm:ss format
awesome! it works..thanks all for the help =)- juniordba
- Post #8
- Forum: Microsoft SQL Server: Programming
-
Converting int to hh:mm:ss format
Hi All, Yup im a newbie to SQL and I've read on cast and convert before asking this question. But basically I have a column (int datatype) that is actually showing a time value. (i.e. 25755 - actually means 2:57:55 in hours:minutes:seconds). Now what I want to do is to do a select on this...- juniordba
- Thread
- Replies: 11
- Forum: Microsoft SQL Server: Programming
