sql日期月份怎么取是单位，比如2011-09-01 >2011-9-1

Question

sql2000中日期转出来的都是 2011-09-01 但我需要这样格式>2011-9-1

Answer 1

select replace('2011-09-01','-0','-')

Answer 2

select replace(convert(varchar(10),getdate(),120),'-0','-')
/*----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
2011-9-1(1 行受影响)*/

Answer 3

declare @t datetime
set @t='2011-09-01'
select ltrim(year(@t))+'-'+ltrim(month(@t))+'-'+ltrim(day(@t))
/*
2011-9-1
*/