SQL查询年，月，日

[gaofzhs]

我有一个表，里面有ID,[TIME]两个字段，[TIME]类型为datetime，比如我想要查询结果只显示年，或月，或日。怎么写？

[青锋-SS]

select id,year([time]) as '年',month([time]) as '月',day([time]) as '日' from tb

[等不到来世]

year(time)

month(time)

day(time)

[青锋-SS]

select id,year([time]) as '年',month([time]) as '月',day([time]) as '日' from tb

[htl258_Tony]

select convert(varchar,[TIME],23) as [time],... from tb

[csdyyr]

year
month
day
datepart
datename

[izbox]

year(time)

month(time)

day(time)

[jiangshun]

select ID,年=year(Time),月=month(time),日=day(time) from 表

[feixianxxx]

select 年=datepart(year,time),月=datepart(month,time),日=datepart(day,time)
from tb

[htl258_Tony]

汗,理解错了.
最简单的用这三个year(),month(),day()

[gaofzhs]

感谢大家，看来僧多肉少……全是正确答案，就给第一个吧

[青锋-SS]

[Quote=引用 10 楼 gaofzhs 的回复:]
感谢大家，看来僧多肉少……全是正确答案，就给第一个吧
[/Quote]汗,僧是不吃肉的.

[zjybushiren88888]

year(time)

month(time)

day(time)