如果把日期之前加入字符呢
select 'edi created ' +cast(getdate() as char(20))
果是
edi created May 19 2007 12:06PM
我希望是的
edi create 2007-05-19 12:06
有有什法
thanks

[解决办法]
select 'edi created ' +convert(nvarchar, getdate(), 120)
[解决办法]


select 'edi created ' +convert(nvarchar, getdate(), 120)

--result
------------------------------------------
edi created 2007-05-19 12:12:34

(1 row(s) affected)