select DateAndTime=convert(char(10),DateAndTime,120)
from Photo_info
group by convert(char(10),DateAndTime,120)改用其它语句可以了~
谁进来接分????
from Photo_info
group by convert(char(10),DateAndTime,120)改用其它语句可以了~
谁进来接分????
SELECT YEAR(DateAndTime) AS Expr1, MONTH(DateAndTime) AS Expr2,
DAY(DateAndTime) AS Expr3
FROM
(select convert(char(10),DateAndTime,120) as DateAndTime
from Photo_info
group by convert(char(10),DateAndTime,120))t