This blog shows how to display the current dae in yy.mm.dd using SQL query

Example:

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

The expected result would be 11.06.16