select CreateDate, * from Machine_MaintainPlanLine order by convert(date, CreateDate) desc
select CreateDate, * from Machine_MaintainPlanLine order by convert(datetime, CreateDate) desc
select CreateDate, * from Machine_MaintainPlanLine order by convert(date, CreateDate) desc
select CreateDate, * from Machine_MaintainPlanLine order by convert(datetime, CreateDate) desc