Tech/DB・SQL
DB별 TO_NUMBER
Enrai
2015. 7. 15. 10:49
Oracle / Tibero
TO_NUMBER('10') |
Mssql
CONVERT(NUMERIC, '10') |
Informix
| TO_NUMBER('10') |
Sybase
CAST('10' AS INT) |
MySQL
| CAST('10' AS UNSIGNED) |
DB2
| CAST('10' AS INTEGER) |
출처 : http://extremeblue.tistory.com/35