第一种
CAST(NAME AS INT);
CAST(65535 AS BINARY);
CAST(CAST(‘FFFF’ AS BINARY) AS INT);
CAST(TIMESTAMP ‘2010-01-01 10:40:00.123456’ AS TIME(6))
第二种
将字符型转换为整型
CONVERT(NAME, INT)
CONVERT(NAME, long)
附上h2数据库函数大全链接http://h2database.com/html/functions.html