db2数据类型转换:
字段为Integer Integer ----> char char(字段)
char -------> Integer Integer(trim(char(字段)))
字段为double(8,2) double ----->char char(cast(字段 as decimal(8,2)))
char ------->double cast(cast(char(cast(a.字段 as decimal(8,2))) as decimal(8,2)) as double)
字段为decimal(8,2) decimal ------->char Digits(字段)
char ------->decimal cast(Digits(字段) as decimal(8,2))
字段为date date ------>char char(字段)
char ------>date date(trim(char(字段)))
字段为bigint bigint ---->char char(字段)
char ----->bigint cast(char(字段) as bigint)
db2数据类型转换函数
最新推荐文章于 2024-07-30 22:31:45 发布