Posted on 2006-07-07
CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(),120), 120)
I am using the above to only get the date and exclude the time.
I get Jul 7 200
Is there a way that I can get 07/07/2006 instead?
I got this convertion from another question that I asked and just cut and paste, but can anyone walk me through with what its doing?