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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.