SELECT CONVERT(VARCHAR(10), DateTimeField, 121) AS DateOnly FROM TableName
SELECT CONVERT(VARCHAR(10), GETDATE(), 121) AS DateOnly
select * from TableName order by convert(varchar,PlanTime,103)
create proc GetApplications @SortField nvarchar(20) as select * from Applications order by case @SortField when 'FirstName' then cast (FirstName as sql_variant) when 'LastName' then cast (LastName as sql_variant) when 'ApplyDate' then cast (ApplyDate as sql_variant) else cast (ID as sql_variant) end
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)