SQL取时间类型的,小时,分钟,秒

select   Convert(varchar(2),datepart(hour,[time])),
  Convert(varchar(2),datepart(minute,[time])),
  Convert(varchar(2),datepart(second,[time]))   from   表

 

 

  select   Convert(varchar(2),datepart(hour,[time]))+':'  
  +Convert(varchar(2),datepart(minute,[time]))+':'  
  +Convert(varchar(2),datepart(second,[time]))   from   表