34,593
社区成员
发帖
与我相关
我的任务
分享
select cast(days as varchar)+'-'+months+'-'+cast(years as varchar)
from
(
select day(getdate()) days, case month(getdate()) when 01 then 'January'
when 02 then 'February'
when 03 then 'March'
when 04 then 'April'
when 05 then 'May'
when 06 then 'June'
when 07 then 'July'
when 08 then 'August'
when 09 then 'September'
when 10 then 'October'
when 11 then 'November'
else 'December' end as months ,year(getdate()) years)a
declare @date datetime
set @date=getdate()
select rtrim(datepart(day,@date))+'-'
+(case month(@date) when 3 then 'March' when 1 then/*英文不咋会*/ end)+'-'+left(year(@date))
--方法一
SELECT CONVERT(VARCHAR(20),GETDATE(),105)
--方法二
SELECT CAST(DATEPART(DD,GETDATE())AS VARCHAR(20))+'-'+cast(DATEPART(MM,GETDATE()) as VARCHAR(20))
+'-'+CAST(DATEPART(YY,GETDATE())AS VARCHAR(20))
--自己拼接啊
set language 'english'
select convert(varchar(12),getdate(),106)
/
------------
16 Mar 2011