在SQL Server中获得不包含时间部分的日期

Select Datename(year,GetDate())+'-'+Datename(month,GetDate())+'-'+Datename(day,GetDate())

Select Datename(hour,GetDate())Select Datename(minute,GetDate())Select Datename(second,GetDate())Select Datename(weekDay,GetDate())Select Datename(week,GetDate())

select convert(char(10),GetDate(),120) as Date

100   mm dd yyyy101   mm/dd/yyyy102   yyyy.mm.dd103   dd/mm/yyyy106   dd mm yyyy108   hh:mi:ss(时间)111   yyyy/mm/dd112   yyyymmdd120   yyyy-mm-dd