select convert(smalldatetime, convert(char(10),SSD_SellRecord.VoucherTime,120)) as VoucherTime
from SSD_SellRecord group by convert(smalldatetime, convert(char(10),SSD_SellRecord.VoucherTime,120))
因为要根据日期来group by,所以用convert(char(10),SSD_SellRecord.VoucherTime,120)截取日期部分。又因为我们希望的最终结果是时间类型,所以还得用convert(smalldatetime, convert(char(10),SSD_SellRecord.VoucherTime,120))进行转换。
转载于:https://www.cnblogs.com/ayi30/archive/2007/01/14/620035.html