How to get rid of the time part from the date returned by GETDATE function? We have to use the CONVERT function to strip the time off the date. SELECT CONVERT(char,GETDATE(),101)