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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.