Avatar of SFWolverine

asked on 

sql keep only date part in datetime format

I have a sql variable 'StartDate' of type DATETIME that shows for example 2/6/2009 12:00:00.  But I only want it to show 2/6/2009 and still keep it as DATETIME type.  I know I can use the convert function, but it switches the variable to a character type.
Microsoft SQL Server

Avatar of undefined
Last Comment
Mark Wills

8/22/2022 - Mon