Sybase 报错:SQL 错误 [247] [ZZZZZ]: Arithmetic overflow during explicit conversion of VARCHAR value '2662727901' to a INT field .

SQL:

select convert(integer, '2662727901');

  

当使用Sybase的convert方法将VARCHAR转为INT时,如果VARCHAR转换后的大小超出了INT类型的最大值,就会有如下报错:

SQL 错误 [247] [ZZZZZ]: Arithmetic overflow during explicit conversion of VARCHAR value '2662727901' to a INT field .

posted @ 2022-04-01 15:46  碣石观沧海  阅读(132)  评论(0)    收藏  举报