To retrieve you results in the mm/dd/yyyy format, try the following two things:
1.
Create a function in SQL Server using the following code:
--start of code
CREATE FUNCTION dbo.DateOnly(@Date datetime)
RETURNS varchar(12)
AS
BEGIN
RETURN CONVERT(varchar(12), @Date, 101)
END
--end of code
2...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.