title: Parsing a time span string in sql
body: <p>I am reading in from a datasource that is giving me time in a varchar in the format <code>d:h:m:s:f</code>, The day portion is always 0, the column represents a time of day. I would like to add this column to a datetime I already have.</p>
  
  <pre><code>Entry_Date          Entry_Time
  3/3/2009 12:00:00   0:16:17:6:0
  8/24/2011 12:00:00  0:8:39:18:0
  9/4/2010 12:00:00   0:12:33:18:0
  </code></pre>
  
  <p>If I was using C# I would just do <code>TimeSpan.ParseExact</code> but I do not know how to handle this in a purely sql fashion.</p>
  
  <p>I would cast to <code>time</code> but I am using Sql Server 2005 and that does not have the <code>time</code> type.</p>
  
  <p>How would I add the time to the neighboring datetime?</p>