in reply to Re^3: convert bigint to int
in thread convert bigint to int

im not getting any errors, i get the correct value which is bigint in the sql column. i need to convert the value from bigint to int. that has nothing to do with the sql connection.

Replies are listed 'Best First'.
Re^5: convert bigint to int
by huck (Prior) on Apr 05, 2017 at 09:01 UTC

    The connect tells us what driver you are using. is it dbi:ODBC?

    if you are getting the correct value of a bigint from your select then what is your problem?

    do you mean you want to make a new table with a int column rather than a bigint column? That is not a perl problem