//转float
SELECT cast('1237878.98989' as FLOAT)
//转int
SELECT cast('1237878' as INTEGER)
postgres字符串转数字
于 2022-08-17 18:08:49 首次发布
//转float
SELECT cast('1237878.98989' as FLOAT)
//转int
SELECT cast('1237878' as INTEGER)