Converting from datetime to varchar and back would be an awful thing to do for looking at a million rows, but performed once per call to modify a stored procedure parameter will not measurably affect performance (unless you are calling the procedure a million times, and then you have bigger problems