SQL How to convert VARCHAR to bigint

Question

I have a field that is VARCHAR 6  I am trying to insert it into another table of type bigint  it is giving me an error   Error Converting from data type varchar to bigint  here is what i am doing  CONVERT bigint  seconds  as seconds   Can anybody help with this issue

User · Answer

I think your code is right  If you run the following code it converts the string  60  which is treated as varchar and it returns integer 60  if there is integer containing string in second it works      select CONVERT bigint  60   as seconds    and it returns  60

User · Answer

This is the answer   CASE   WHEN      isnumeric ts TimeInSeconds    1     THEN     CAST ts TimeInSeconds AS bigint    ELSE     0   END  AS seconds

User · Answer

an alternative would be to do something like   SELECT    CAST P0 seconds as bigint  as seconds FROM         SELECT       seconds    FROM       TableName    WHERE       ISNUMERIC seconds    1      P0

[sql] SQL, How to convert VARCHAR to bigint?

Examples related to sql

Examples related to sql-server