请看下面的sql语句。select b.name as 工程名称,a.contract_amount as 总投资,c.name as 类别,datediff(day,a.contract_start,a.contract_end) as 工期
from prj_succereg a
left join prj_tendinfo b on b.pkid=a.prj_tendinfo_id
left join base_projectclass c on c.pkid=a.base_projectclass_id
--
datediff(day ,start_date,end_date)函数运算出来的结果:工期
197
184
663
275
730
1095
546
181
150
93
518
88
这些在表里表示天数。如何能在查询出来的结果集中 每条数据都加上一个字?比如197天
184天
663天...
so on...?比较急,高手不要吝啬啊,谢谢中!
from prj_succereg a
left join prj_tendinfo b on b.pkid=a.prj_tendinfo_id
left join base_projectclass c on c.pkid=a.base_projectclass_id
--
datediff(day ,start_date,end_date)函数运算出来的结果:工期
197
184
663
275
730
1095
546
181
150
93
518
88
这些在表里表示天数。如何能在查询出来的结果集中 每条数据都加上一个字?比如197天
184天
663天...
so on...?比较急,高手不要吝啬啊,谢谢中!
from prj_succereg a
left join prj_tendinfo b on b.pkid=a.prj_tendinfo_id
left join base_projectclass c on c.pkid=a.base_projectclass_id
SELECT CAST(DATEDIFF(dd,'2009-05-24',getdate()) AS VARCHAR(10)) + '天'
select b.name as 工程名称,a.contract_amount as 总投资,c.name as 类别,CAST(datediff(day,a.contract_start,a.contract_end) as VARCHAR(10)) + '天' as 工期
from prj_succereg a
left join prj_tendinfo b on b.pkid=a.prj_tendinfo_id
left join base_projectclass c on c.pkid=a.base_projectclass_id
修改为select cast(datediff(day,a.contract_start,a.contract_end) as varchar(20)) as 工期
b.name as 工程名称,a.contract_amount as 总投资,c.name as 类别,
ltrim(datediff(day,a.contract_start,a.contract_end))+'天' as 工期
from prj_succereg a
left join prj_tendinfo b on b.pkid=a.prj_tendinfo_id
left join base_projectclass c on c.pkid=a.base_projectclass_id
from prj_succereg a
left join prj_tendinfo b on b.pkid=a.prj_tendinfo_id
left join base_projectclass c on c.pkid=a.base_projectclass_id
2:select b.name as 工程名称,a.contract_amount as 总投资,c.name as 类别,convert(varchar(10),datediff(day,a.contract_start,a.contract_end) )+'天' 工期
from prj_succereg a
left join prj_tendinfo b on b.pkid=a.prj_tendinfo_id
left join base_projectclass c on c.pkid=a.base_projectclass_id