I need to use (I think) the GETDATE() function to return the current date, but I need to make sure that it is only the date and no time, or at least time to be 0.
Is this the right way to go about it
CONVERT(DateTime, CONVERT(Char, GETDATE(), 103), 103))
or is there a better way
Thanks in advance