Can anybody please explain me this expression?
CONVERT(datetime, CONVERT(varchar, GETDATE(), 1)

thanks.

This is the command which first convert current date time into varchar then the result is again converted to datetime datatype.

This is the command which first convert current date time into varchar then the result is again converted to datetime datatype.