select year(dtTime) [year],month(dtTime) [month],day(dtTime) [day] from temp
select datepart(year,dtTime) [year],datepart(month,dtTime) [month], datepart(day,dtTime) [day] from temp
use tempdb; /* create table tb ( content datetime not null ); insert into tb(content) values ('2002/2/3 0:00:00'); */ select YEAR(content) as [年], MONTH(content) as [月], DAY(content) as [日] from tb;
datepart(day,dtTime) [day] from temp
use tempdb;
/*
create table tb
(
content datetime not null
);
insert into tb(content)
values
('2002/2/3 0:00:00');
*/
select
YEAR(content) as [年],
MONTH(content) as [月],
DAY(content) as [日]
from tb;
select GETDATE()--1)
select YEAR(dtTime) 年, MONTH(dtTime) 月,DAY(dtTime)日 from #tb--2)
select DATEPART(YEAR,dtTime)年,DATEPART(MONTH,dtTime) 月,DATEPART(DAY,dtTime) 日 from #tb结果年 月 日
----------- ----------- -----------
2011 4 29(1 行受影响)年 月 日
----------- ----------- -----------
2011 4 29(1 行受影响)