title: SQL, How to convert VARCHAR to bigint?
body: <p>I have a field that is <code>VARCHAR(6)</code> I am trying to insert it into another table of type <code>bigint</code>  it is giving me an error</p>
  
  <p>(Error Converting from data type varchar to bigint</p>
  
  <p>here is what i am doing</p>
  
  <pre><code>CONVERT(bigint, seconds) as seconds
  </code></pre>
  
  <p>Can anybody help with this issue?</p>