急！！100分帮我写条SQl语句呀

Question

大哥们帮我看看这条SQL怎么写呀现在我我有一张表 （如下）
StarTime                   ActiveName 
2006-04-03 09:00:00          早饭
2006-04-03 10:00:00          开会
2006-04-03 15:00:00          自由活动2006-04-04 09:00:00          开会
2006-04-04 10:00:00          午饭
2006-04-04 11:00:00          自由活动2006-04-05 08:00:00          开会
2006-04-05 10:00:00          开会
2006-04-05 11:00:00          自由活动我想查出一张表数据显示为（如下）这条SQl怎么写呀
StarTime                
2006-04-04
2006-04-05 
2006-04-06

Answer 1

select dateadd(day,1,StarTime) from tablename

Answer 2

select convert(varchar(10),dateadd(day,1,StarTime),120) from tablename

Answer 3

不好意思。刚才有个地方写错了我想查出一张表数据显示为（如下）这条SQl怎么写呀
StarTime
2006-04-03                
2006-04-04
2006-04-05 

Answer 4

select distinct StarTime from tablename

Answer 5

select distinct convert(varchar(10),StarTime,120) from tablename