通过:Select col as “字段名” from dual 的方式,如何将“字段名”设置为:10.1-10.7(MM.DD)的格式,日期为动态取的日期,结果为: 10.1-10.7
-----------------
5500参考语句为:
select 5500 as to_char(sysdate,'MM.DD')||'-'||to_char(sysdate+7,'MM.DD') from dual (本语句有错,仅表达意思)
-----------------
5500参考语句为:
select 5500 as to_char(sysdate,'MM.DD')||'-'||to_char(sysdate+7,'MM.DD') from dual (本语句有错,仅表达意思)
DECLARE @STR VARCHAR(100)
SET @STR='select 5500 as ['+LEFT(CONVERT(VARCHAR(20),GETDATE(),11),5)+ '-'+ LEFT(CONVERT(VARCHAR(20),GETDATE()+7,11),5)+']'
EXEC(@STR)/*結果:
07/11-07/11
-----------
5500(1 row(s) affected)
*/
SET @STR='select 5500 as ['+REPLACE(LEFT(CONVERT(VARCHAR(20),GETDATE(),10),5),'-','.')+ '-'+ REPLACE(LEFT(CONVERT(VARCHAR(20),GETDATE()+7,10),5),'-','.')+']'
EXEC(@STR)/*結果:
11.01-11.08
-----------
5500(1 row(s) affected)
*/