select convert(char(7),cast(字段 as datetime),120)from tb
declare @date varchar(10) ,@d varchar(50) set @d='2009-2-23' --1 set @date=datename(yy,cast(@d as datetime))+'-'+datename(mm,cast(@d as datetime)) --2 set @date=convert(varchar(7),cast(@d as datetime),120) select @date
select month(getdate())
declare @date varchar(10)
--1
set @date=datename(yy,getdate())+'-'+datename(mm,getdate())
--2
set @date=convert(varchar(7),getdate(),120)
select @date
select convert(char(7),getdate(),120) /**
2009-02
**/
set @d='2009-2-23'
--1
set @date=datename(yy,cast(@d as datetime))+'-'+datename(mm,cast(@d as datetime))
--2
set @date=convert(varchar(7),cast(@d as datetime),120)
select @date
2009-02-23 13:27:41(1 row(s) affected)字段需要到哪就截取到哪!
2009-02
**/
set @d='2009-2-23'
select ltrim(datepart(yy,@d))+'-'+ltrim(datepart(mm,@d)) as d
/*
d
------
2009-2
(所影响的行数为 1 行)
*/
select datepart(yyyy,getdate()) --获取年
select datepart(mm,getdate()) --获取月
select datepart(dd,getdate()) --获取日