This blog shows how to display the current dae in mm/dd/yyyy using SQL query

Example:

SELECT CONVERT(varchar(20), GETDATE(), 101)

The expected result would be 06/16/2011