按照你的想法建议你连接f1和f2在代码里实现string.padleft(4,"0"); 第二个处理日期你需要将f8设置为Date 然后在SQL中使用year() 例如select cast(year(DateCloumn) as varchar(10))+cast(month(DateCloumn) as varchar(10))+cast(day(DateCloumn) as varchar(10)) as DateCloumn from TableName
关于日期我的sql与句是这么写的,可是不好用呀? select cast(year(F8) as varchar(10))+cast(month(F8) as varchar(10))+cast(day(F8) as varchar(10)) as F8 from LIB.A4G63ALH
关于两个列合并我的sql与句是这么写的,可是不好用呀? select (f4 + left('0000',4-length(f5)) + cast(f5 as char)) as f10 from LIB.A4G63ALH
如果你的f5不超过4位数的话用下面的语句能实现实现 select f1,f2,f3,(f4 + left('0000',4-len(f5)) + cast(f5 as varchar(4))) as f4,f6 as f5,f7 as f6,f8 as f7,f9 as f8 from table1
日期的可以 (cast(year(f8) as varchar(4))+cast(month(f8) as varchar(2))+cast(day(f8) as varchar(2))) as f7
我的sql这么写的: select f1,f2,f3,(f4 + left('0000',4-Length(f5)) + cast(f5 as varchar(4))) as f4,f6 as f5,f7 as f6,f8 as f7,f9 as f8 from lib.A4G63ALH 可是在sql里面运行结果就是这样的: + use not valid.
Oracle用
select f1||ToChar(f2) As f3 from yourtable
select (f1 + left('0000',4-len(f2) + cast(f2 as char)) as f3 from table1
select (f1 + left('0000',4-len(f2)) + cast(f2 as char)) as f3 from table1
f1 f2 f3 f4 f5 f6 f7 f8 f9
1860 314 5 SAE 820 G4-28 4G636TT 2001.5.25 DN
1861 314 5 SAD 1124 G4-28 4G636TT 2001.5.25 DN
我想把其中的SAE和820 组合成 SAE0820,SAE和1124组合成SAD1124合成后的表结构为:
f1 f2 f3 f4 f5 f6 f7 f8
1860 314 5 SAE0820 G4-28 4G636TT 20010525 DN
1861 314 5 SAD1124 G4-28 4G636TT 20010525 DN
不知道我现在说的明不明白?
第二个处理日期你需要将f8设置为Date 然后在SQL中使用year()
例如select cast(year(DateCloumn) as varchar(10))+cast(month(DateCloumn) as varchar(10))+cast(day(DateCloumn) as varchar(10)) as DateCloumn from TableName
select cast(year(F8) as varchar(10))+cast(month(F8) as varchar(10))+cast(day(F8) as varchar(10)) as F8 from LIB.A4G63ALH
select (f4 + left('0000',4-length(f5)) + cast(f5 as char)) as f10 from LIB.A4G63ALH
select f1,f2,f3,(f4 + left('0000',4-len(f5)) + cast(f5 as varchar(4))) as f4,f6 as f5,f7 as f6,f8 as f7,f9 as f8 from table1
select f1,f2,f3,(f4 + left('0000',4-Length(f5)) + cast(f5 as varchar(4))) as f4,f6 as f5,f7 as f6,f8 as f7,f9 as f8 from lib.A4G63ALH
可是在sql里面运行结果就是这样的:
+ use not valid.
F1 A4G63ALH NUMERIC 4
F2 A4G63ALH NUMERIC 3
F3 A4G63ALH NUMERIC 1
F4 A4G63ALH CHARACTER 3
F5 A4G63ALH NUMERIC 4
F6 A4G63ALH CHARACTER-O 5
F7 A4G63ALH CHARACTER-O 9
F8 A4G63ALH CHARACTER-O 9
F9 A4G63ALH CHARACTER 2
列名 表名 列属性 长度
F1 A4G63ALH NUMERIC 4
F2 A4G63ALH NUMERIC 3
F3 A4G63ALH NUMERIC 1
F4 A4G63ALH CHARACTER 3
F5 A4G63ALH NUMERIC 4
F6 A4G63ALH CHARACTER-O 5
F7 A4G63ALH CHARACTER-O 9
F8 A4G63ALH CHARACTER-O 9
F9 A4G63ALH CHARACTER 2
(f4 + left('0000',4-Length(f5)) + cast(f5 as varchar(4))) as f4